Recovery Catolog DB: CATDB11
Version: 11.2.0.1.0
1. Create the recovery catalog database as usual.
2. Using SQL*Plus, connect to the recovery catalog CATDB11 with administrator privileges.
sqlplus '/as sysdba'
3. Create a user that will be the owner of the recovery catalog.
SQL> CREATE USER rman11 IDENTIFIED BY password
DEFAULT TABLESPACE USERS
QUOTA UNLIMITED ON USERS;
4. Grant the rman11 user the RECOVERY_CATALOG_OWNER role.
SQL> GRANT recovery_catalog_owner TO rman11 ;
5. Start RMAN and run the following RMAN commands to connect to the recovery catalog database as rman11 and create the recovery catalog:
RMAN> CONNECT CATALOG rman11/rman11@CATDB11
RMAN> CREATE CATALOG;RMAN> CONNECT CATALOG rman11/rman11@CATDB11
connected to recovery catalog database
RMAN>
6. In the same RMAN session, you connect to a target database using operating system authentication and use the REGISTER DATABASE command to register this database in the catalog:RMAN> CREATE CATALOG;
recovery catalog created
RMAN> CONNECT TARGET /
RMAN> REGISTER DATABASE;
RMAN> EXITRMAN> REGISTER DATABASE;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
To List Currently Registered Databases:
SQL> set pages 999
SQL> select * from rc_database order by NAME;