René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Registering a database with the Recovery Catalog

If a recovery catalog is used for rman operations, the database to be backed up (and possibly recovered) needs to be registered with the recovery catalog.
Of course, the catalog must have been created previously.
In the following example, the target database is named ORA9.
In order to register a database, there needs to be a user with sysdba privileges. In the following case, this user is called rman_admin. 
$ rman target=rmanadmin/rmanpw@ora9 catalog=catowner/catpw@cat
RMAN is started, the database can be registered: 
RMAN> register database;
If the user doesn't have sysdba privileges, the following error is thrown: 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
The registered database can be found in the rc_database view. 
SQL> select * from catowner.rc_database;

    DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS
---------- ---------- ---------- -------- ----------------- ---------
         1          2  318012771 ORA9                     1 10-MAR-05