Amen Sister. You took the words right out of my mouth. I would also add that on our platform (HP-UX, Netbackup), the integration between RMAN and our Netbackup libraries is great. All my Oracle backups go right into the company infrastructure jukebox and the tape management handled by the operations staff.
> -----Original Message----- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 1:19 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RMAN > > > Well, to start: > > Block level backup, though it may have it's problems that you > elude to, > allows compact backups for very large databases. I have > never had a backup > fail because of block locking. > > Incremental backups to save resources on very large databases. > > The ability to report on your recoverability through rman. > > Backups are less intrusive since they are block level. The > problem of the > batch job that went haywire, ran into the hot backup window > and caused a > boatload of arclogs to be written, is no longer a problem. > It's still not > good practice to backup during batch, we all know that, but > if you don't > have a choice (or if it all hits the fan) rman makes it less painful. > > And as someone mentioned earlier, checking for corruption > during the backup > process. > > But I digress.. I think it is well worth the effort. > > Just my 2 cents. Again, it could be the hormones talking. I > love that > excuse :) > > > > > -----Original Message----- > > From: Dave Morgan [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, April 04, 2002 11:55 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: RMAN > > > > Hi Lisa, Steve, > > But what advantage do you gain by taking the two days > > to install RMAN? > > > > The only one I can think off is the block level backup > > but that can create problems of it's own. They used > > to do block level backup in the 60's and gave that up > > because of the complexity. > > > > Disadvantages: > > - another database to backup > > - another dependency (ooooh I hate those) > > - upgrades and version conflicts > > > > > > My scripts do hot backups to disk or tape, allow choice > > of tablespaces and will backup tablespace files in parallel > > according to the number of CPU's. The last major change > > I made to them was from Oracle 6 to Oracle 7.0. The biggest > > advantage is that the procedure to recover every database > > is exactly the same. RMAN starts with which catlaog do I > > connect to. > > > > My recovery command (for the easy ones at least) is: > > > > recover database auto in svrmgrl. > > > > Apart from that, DBA's who have never used anything but > > RMAN may be able to recover but usually do not understand > > the underlying concepts and so are unable to figure > out what > > to do when problems during recovery arise. > > > > > > Dave > > > > > > -- > > Dave Morgan > > DBA, Cybersurf > > Office: 403 777 2000 ext 284 > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Dave Morgan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / > Mailing Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Koivu, Lisa > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).