Configure catalog Practical

Configure catalog

Target database (prod) Side:-

$ export ORACLE_SID=prod

$ sqlplus / as sysdba

SQL> startup

Catalog database (test) Side:-

$ export ORACLE_SID=test

$ sqlplus / as sysdba

SQL> startup

Create a tablespace---

SQL> create tablespace cat datafile '/u01/home/test/cat01.dbf' size 50m autoextend on;

Create a user---

SQL> create user cat identified by cat;

SQL> grant connect,resource,recovery_catalog_owner to cat;

SQL> alter user cat default tablespace cat;

SQL> exit

~]$ rman catalog cat/cat

RMAN> create catalog;

SQL> exit

$ netmgr (create listener) -----(service name= Catalog database name)

$ lsnrctl start list_cat

Target database (prod) Side:-

SQL> exit

$ netmgr(create tns) -----(service name= Catalog database name)

$ tnsping tocat

]$ rman target / catalog cat/cat@tocat

RMAN> register database;

Catalog database (test) Side:-

$ sqlplus / as sysdba

SQL> conn cat/cat

SQL> select * from rc_database;

Taking backup of Target db with Catalog From the Target host connect to rman

Target database (prod) Side:-

RMAN> exit

~]$ sqlplus / as sysdba

SQL> archive log list  (enable)

SQL> exit

~]$ rman target / catalog cat/cat@tocat

RMAN> list db_unique_name all;

RMAN> backup database;

Catalog database (test) Side:-

SQL> select DB_NAME,FILE#,FILESIZE,TSNAME from RC_BACKUP_DATAFILE_DETAILS;

VIEWS:-

dba_tablespaces;

dba_data_files;

dba_users;

session_privs;

rc_database;

RC_BACKUP_DATAFILE_DETAILS;