Bill ; I am just in the process of implementing RMAN at our shop. We decided to go with RMAN for the following reasons :
* Reason1 RMAN manages what backups are required to perform the restore and where the backup are located (will get the files off tape). * Reason 2 The ability to perform HOT backups without the "ALTER TABLESPACE ..BEGIN/END" commands. This will reduce the amount of REDO that is generated during the backup. IE: You get HOT backups with out the adverse impact of the volume of redo. Since a datafile does not have to be placed in backup mode - there is no risk of the database going down during a hot backup and asking for media recovery. * Reason 3 The ability to only backup "used" Oracle blocks. This greatly reduces the amount of data that needs to be backed up. BACKUP SETS - Will only copy database blocks containing data. This saves on IO by not copying empty blocks. * Reason 4 The ability to detect database block corruption. Because RMAN uses Server Processes to perform its backup reads - it will raise the same error a SQL statement will raise upon detection of something amiss inside a database block. * Reason 5 The ability to perform incremental backups and restores. This greatly reduces the amount of data that needs to be backed up (block level backups). LEVEL 0 - Will copy all database blocks containing data (FULL). This saves on IO by not copying empty blocks. LEVEL 1 - Will copy database blocks that have changed since the most recent level0 bkup. This further reduces IO. LEVEL 2 - Will copy database blocks that have changed since the most recent level1 bkup. This further reduces IO. * Reason 6 A Enterprise Centralized Backup and Recovery solution. _________________________ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Olympia, WA 98507 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe 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).
