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

Only concern with backup times when writing to tape - Previous experience (albeit dated) makes me think RMAN to tape with Netbackup is going to be slower than acceptable but perhaps not.

We're definitely going to go with RMAN to tape as our first pass to get some timings and performance metrics to see where we are.

Thanks,
Chris

On Tue, Jul 12, 2016 at 2:43 PM, Dimensional DBA < dimensional.dba_at_comcast.net> wrote:

> A better question may be to ask why is 5TB backup a challenge?
>
> I have clients with 30TB OLTP databases that we backup FULL twice a week
> and clients with 500TB EDW that we backup weekly to tape and to disk.
>
>
>
> What problems are you having that you are asking the question for other
> options?
>
>
>
> *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 *Chris Taylor
> *Sent:* Tuesday, July 12, 2016 10:42 AM
> *To:* ORACLE-L
> *Subject:* Looking for Suggestions - 5 TB DB WHSE Backup options
>
>
>
> 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
>

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