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
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe