Description: RDB1 as TARGET SERVER
RDB2 as CATALOG SERVER
- create a database using DBCA on catalog server as catalog database i.e. RDB
- create a service in target server for the catalog server connection.
- check service alias using TNSPING servicename(EX:TNSPING RDB2) in terminal prompt
- set oracle_sid=RDB2
- conn sys@RDB2 as sysdba
- create user rman_user identified by rman_user default tablespace USERS;
- grant resource,connect,recovery_catalog_owner to rman_user;
- set oracle_sid=RDB1
- connect to RMAN
- connect target /
- connect catalog rman_user/rman_user@RDB2
- create catalog tablespace users;
- register database;
- connect in toad using RDB2 and run this :
select * from rman_user.rc_database(name column : RDB1)