Oracle Tips by Burleson

Oracle10g RMAN Simplified Recovery Manager Cataloging of Backup Files

Every time RMAN backs up a database into backup sets and backup pieces, it updates the RMAN catalog to reflect the backup information.  If a user removes, relocates, or renames a backup piece, you cannot make corresponding changes to the RMAN catalog in the earlier versions of the oracle database. 

However, in Oracle 10g, you can use the CATALOG command to enter the new filename or location for backup pieces in the RMAN catalog.  In addition, you can use the CATALOG command to enter user-managed data file copies. The UNCATALOG command is used to remove the backup pieces from the catalog.

Example 1: To catalog a backup piece

RMAN> catalog backuppiece
   2> ‘/dba/backup/rman/data01.bkp’;

Example 2: To catalog a user-managed data file copy

RMAN> catalog backup
   2> ‘/dba/backup/grid/data01.dbf’;

Example 3: To uncatalog a backup piece

RMAN> change backupiece
   2> ‘/dba/backup/grid/data01.bkp’ uncatalog;

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm