How To Create RECOVERY CATALOG

• Check the ORACLE_HOME and ORACLE_SID

export ORACLE_SID=test

sqlplus / as sysdba

• Create tablepspace

SQL>  create tablespace mumbai datafile '/u01/app/oracle/oradata/test/bangalore.dbf' size 100m;

SQL>  create user suresh identified by vivek default tablespace bangalore quota unlimited on bangalore;

SQL>  grant connect, resource to vivek;

SQL>  grant recovery_catalog_owner to vivek;

R==> export ORACLE_SID=test

rman target /

connect catalog suresh/suresh

create catalog tablespace bangalore;

register database;

backup tablespace users;

• How to check table of recovery catalog

SQL>  select table_name from dba_tables where tablespace_name='Bangalore';

• Now from user's login

 RMAN> show device type;

RMAN> show default device type;

RMAN> crosscheck backup;

RMAN> configure device type sbt_tape clear;

  

• To check the location of backup:

SQL> show parameter db_recovery_file_dest;

SQL> show parameter control_file_record_keep_time;

SQL> show parameter db_recovery_file_dest_size;

SQL> show parameter NLS_DATE_FORMAT;

SQL> show parameter NLS_LANG;