Two reasons for RMAN over split mirror:

1. Buying 40TB of disk was pretty much out of the question.

2. split mirrors don't give the opportunity for incremental backups so you
have to decide if you're going to backup 20TB every nightly or roll forward
through multiple days.

-M

-----Original Message-----
From: Kennedy, Jeffrey [mailto:jkennedy AT qualcomm DOT com]
Sent: Wednesday, August 11, 2004 2:31 PM
To: Donaldson, Mark - Broomfield, CO; 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


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