Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: