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