With databases that size tape just doesn't seem to be much of an option
to me.  Why not mirror the stuff and backup the mirror after a break?

I know I know, 20tb is not a small chunk of disk.  But if it's important
it's worth it.  What is the recovery time on a 20tb Oracle db from tape?

~JK

> -----Original Message-----
> From: veritas-bu-admin AT mailman.eng.auburn DOT edu [mailto:veritas-bu-
> admin AT mailman.eng.auburn DOT edu] On Behalf Of Mark.Donaldson AT cexp DOT 
> com
> Sent: Wednesday, August 11, 2004 11:24 AM
> To: Phil.Stockton AT rs-components DOT com; veritas-bu AT mailman.eng.auburn 
> DOT edu
> Subject: RE: [Veritas-bu] Large Oracle/SAP Database and Netbackup
> 
> We did the RMAN thing on our 20TB Oracle DB at my last job.  Solaris,
NB
> 4.5, L700 w. LTO-1.
> 
> There were lots of problems when we went to do our weekly fulls.  Last
I
> heard, my replacement is/was working a ticket through VOSS support.
Turns
> out that there was a core assumption in Netbackup that the whole DB
could
> be
> backed up in 24 hours.  The problem manifested when the RMAN &
Netbackup
> catalogs were sync'd - they wouldn't sync right & tracking info would
be
> lost.  Sorry - since I left I'm a big short on details.
> 
> We did weekly full backups & daily incrementals via RMAN.  We had to
> implement restart code in the RMAN script because the smallest fault
in
> backups, and easy to get a fault over 20 TB of data transfer, would
kill
> the
> whol backup.
> 
> We used the RMAN keyword "NOT BACKED UP SINCE '<date>'" to implement a
> sort-of point-in-time restart of a failed RMAN backup.
> 
> Store the start time of the backup script in a variable, capture the
RMAN
> return code and loop a restart using the "NOT BACKED UP SINCE" command
if
> it's non-zero.  Implement a counter so you don't loop forever in the
event
> of a persistent error state.  It combats the tape errors, network
hiccups,
> etc. pretty well, though.
> 
> HTH - M
> 
> 
> -----Original Message-----
> From: veritas-bu-admin AT mailman.eng.auburn DOT edu
> [mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Phil
> Stockton
> Sent: Wednesday, August 11, 2004 8:17 AM
> To: 'veritas-bu AT mailman.eng.auburn DOT edu'
> Subject: [Veritas-bu] Large Oracle/SAP Database and Netbackup
> 
> 
> Hello Everyone,
> 
> We are looking at having a 6 terabyte Oracle/SAP database in place.
> 
> The environment is Solaris.
> 
> The current tape library is a StorageTek L700.
> 
> Does anybody have a similar environment?  If so, how do you perform
> backups?.  We are a 24/7  business and are not allowed to bring down
> Oracle/SAP for backups.
> 
> We are thinking of RMAN and/or snapshot technology combined with
whatever
> is
> SAP orientated.
> 
> Any advice would be appreciated very much.
> 
> Regards
> 
> Phil Stockton and Oracle 9.
> 
> 
> ***************************************************************
> The contents of this Email and any files transmitted with it
> are confidential and intended solely for the use of the
> individual or entity to whom it is addressed. The views stated
> herein do not necessarily represent the view of the company.
> If you are not the intended recipient of this Email you may not
> copy, forward, disclose or otherwise use it or any part of it
> in any form whatsoever. If you have received this mail in
> error please Email the sender.
> ***************************************************************
> 
> RS Components Ltd.
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu