The recovery catalog contains critical backup details contained in the target database control file. The catalog can be used to recover the target database, especially when the target database control file is not available. What if you'd like to have a redundant catalog for your RMAN backups? Here's how:
1. Export the catalog owner to a binary dump file
2. Import the catalog owner to a different user on another database
3. Connect to each target database and to the new catalog user
4. Issue the resync command
5. After each backup of the target databases, connect to target database and the new catalog user and issue the resync command.
Get more tips in minutes! Return to the main page.
About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.
IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.