Re: Looking for Suggestions - 5 TB DB WHSE Backup options

I'm fairly certain I replied already as to why I was looking for other options, but I'll recap here:

Past experience (probably outdated now) with tape drive throughput was (is) a concern for me but my storage and backup guys assure me that we should be able to backup the database to tape with very little heartburn. So that's going to be our first approach. We're going to start with weekly fulls and nightly incrementals to see where we are. Once we determine if the timing is serviceable, we'll either try a different strategy or go with straight to tape.

My apologies if you guys were waiting on another response from me on this - from my POV, I thought this topic had been addressed and put to bed.

Thanks,
Chris

On Mon, Jul 18, 2016 at 11:18 PM, Dimensional DBA < dimensional.dba_at_comcast.net> wrote:

> It would really be nice to hear from Chris Taylor, the original poster as
> to what is the real problem is as to why 5TB backups are a problem for him.
>
>
>
> Mladen there is more than one solution, including ones that are tape only
> without any disks, but the original database disks. There are a variety of
> technological solutions with what Chris has and what he doesn’t have, but
> more information is needed from Chris.
>
>
>
> In most cases unless you are using very expensive Tier 1 SAN storage, tape
> can actually outrun disk and you can use multiple channels with tape also
> without lag. It really goes back to the Infrastructure architecture.
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *Dimensional DBA*
>
> *425-891-7934 <425-891-7934> (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
> www.dimensionaldba.com
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mladen Gogala
> *Sent:* Monday, July 18, 2016 7:48 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Looking for Suggestions - 5 TB DB WHSE Backup options
>
>
>
> On 07/12/2016 01:42 PM, Chris Taylor wrote:
>
> Ok, guys & gals, I'm looking for suggestions for the following challenge.
> I'm very familiar with RMAN fulls w/ incrementals writing either to disk or
> directly to tape. What I'm NOT familiar with is other options that I may
> not know of and that's where I need your help.
>
>
>
> Objective:
> Nightly backups of 5 TB Data Warehouse that is currently being snapshotted
> weekly at the SAN Layer instead of tape or disk based backups.
>
>
>
> Hardware/OS:
>
> IBM XIV Storage (not sure of model #)
>
> RedHat Linux OS (5.x)
>
> Oracle 11.2.0.4
>
> Netbackup is tape solution
>
>
>
> Method Options:
>
> 1. RMAN Fulls on Weekend, (either to disk or direct to tape) with nightly
> incrementals. I'm leaning toward disk based backups which are then written
> to tape and using parallel threads for the disk based backup to prevent
> overwhelming our tape library
>
>
>
> 2. Other options?
>
>
>
> Chris
>
>
> Well, there aren't many options. You must do database backup to disk, so
> that you can use multiple channels and benefit from the disk speed, while
> copying to tape in the background, possibly with a considerable lag. The
> details are a matter of choice. Any backup software can do that. Not much
> to think about, really.
>
>
>
> --
>
> Mladen Gogala
>
> Oracle DBA
>
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l