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).