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

This was first published in October 2002

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.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: