Friday , October 20 2017
Home / Oracle DBA / ORACLE RECOVERY CATALOG CONFIGURING

ORACLE RECOVERY CATALOG CONFIGURING

ORACLE RECOVERY CATALOG CONFIGURING

ORACLE RECOVERY CATALOG CONFIGURING

  1. RMAN will store the backup information in target database controlfile. If we lost this controlfile and perform either complete or incomplete recovery, we will loose backup info even though physically backups are available
  2. To avoid this situation RMAN introduced recovery catalog. It is a database which stores target database backup information
  3. Single recovery catalog can support multiple target databases
  4. We cannot obtain recovery catalog information from target but vice versa is possible

Steps for Configuring Recover Catalog

SQL> create tablespace rmantbs
         datafile ‘/datafiles/prod/rmantbs01.dbf’ size 50m;
SQL> create user rman_rc identified by rman_rc
         default tablespace rmantbs
         temporary tablespace temp;
SQL> grant connect,resource,recovery_catalog_owner to rman_rc;
[oracle@server1 ~]$rman catalog rman_rc/rman_rc@rc
RMAN> create catalog;
[oracle@server1 ~]$rman target / catalog rman_rc/rman_rc@rc
RMAN> register database;

# To obtain target database information from catalog

SQL> select db_id,name from rc_database;
View More:
ORACLE BACKUP DATABASE RECOVERY
ORACLE MISCELLANEOUS INTERVIEW QUESTIONS
PERFORMANCE TUNING INTERVIEW QUESTIONS

Comments

comments

Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

Your email address will not be published. Required fields are marked *