Problem solve Get help with specific problems with your technologies, process and projects.

Setting up a recovery catalog

I want to install an Oracle 8.1.7 server that will have a recovery catalog running on the same machine. On that server, my database is Marine, and it will be the only database running on that server. My recovery catalog's name will be MarineCat. But I want my recovery catalog to run on that same machine. What is the process to create this environment? How can I ensure that when my recovery catalog is created, I will run the command: RMAN CATALOG RMAN/RMAN@MARINECAT instead of RMAN CATALOG RMAN/RMAN@MARINE or RMAN CATALOG RMAN/RMAN@OEM?

I have to strongly recommend against putting your recovery catalog in the same database that you will be backing up. If you do this, you will never be able to use RMAN to recovery this database! This essentially makes every single backup you take with this configuration, impossible to use. You will be in a Catch-22 situation when you try to recover and restore your database. You'll need to restore the database to get to your catalog. And you'll need the catalog to restore your database. See the problem?

Please put your recovery catalog in a separate database instance. And this instance should also be on a different server. This has been defined by Oracle IT pros as a "best practice".

For More Information

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.