Q

Creating a Recovery Catalog in Oracle 8i

How do I create a Recovery Catalog in Oracle 8i?

How do I create a Recovery Catalog in Oracle 8i?
Creating a Recovery Catalog is quite easy. First, identify the database that will hold the RC. Sign on to that database as SYSTEM or SYS and perform the following actions:

  1. Create a user for the RC. I will call that user RMAN in my example.
  2. Create a tablespace to hold the RC.
  3. Make this tablespace the default tablespace for the RMAN user.
  4. Grant the RECOVERY_CATALOG_OWNER role to the RMAN user.
  5. From RMAN, connect to the RC database:

       os_prompt> rman catalog rman/pswd
    

  6. Create the RC:

       rman> create catalog;
    

Of course, this is all fully documented in the Oracle docs.
This was first published in August 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close