ORACLE RECOVERY CATALOG CONFIGURING

ORACLE RECOVERY CATALOG CONFIGURING

ORACLE RECOVERY CATALOG CONFIGURING 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 To avoid this situation RMAN introduced recovery catalog. It is a database which …

Read More »

ORACLE RMAN RECOVERY SCENARIOS WITH EXAMPLES

RECOVERY MANAGER (RMAN) ARCHITECTURE

ORACLE RMAN RECOVERY SCENARIOS STEPS to recover a datafile RMAN>run{sql ‘alter tablespace mydata offline’;restore tablespace mydata;recover tablespace mydata;sql ‘alter tablespace mydata online’;} STEPS to recover a system datafile RMAN>run{shutdown immediate;startup mount;restore datafile 1;recover datafile 1;sql ‘alter database open’;} STEPS to recover a redolog files RMAN>run{shutdown immediate;startup mount;set until scn 1234; …

Read More »

RECOVERY MANAGER (RMAN) ARCHITECTURE

RECOVERY MANAGER (RMAN) ARCHITECTURE

 RECOVERY MANAGER (RMAN) ARCHITECTURE RECOVERY MANAGER It is the backup methodology introduced in 8.0 which performs block level backup i.e RMAN will take the backup of only used blocks RMAN will take the information from bitmap block about used blocks and while performing this RMAN will make sure DBWRn is …

Read More »

STEPS FOR ORACLE CONTROFILE COMPLETE RECOVERY

control file complete recovery

STEPS FOR ORACLE  CONTROFILE   COMPLETE RECOVERY SQL> alter database backup controlfile to trace; The above command may not work sometimes, in which case we need to use already taken trace file during backup. This command will generate a controlfile script in udump in the form of trace file. SQL> …

Read More »

ORACLE BACKUP DATABASE RECOVERY

ORACLE BACKUP DATABASE RECOVERY

BACKUP DATABASE RECOVERY Recover is of 2 types Complete recovery – recovering database till the point of failure. No data loss Incomplete recovery – recovering to a certain time or scn. Has data loss We will perform complete recovery if we lost only data files. We will perform incomplete recovery …

Read More »

ORACLE MISCELLANEOUS INTERVIEW QUESTIONS

MISCELLANEOUS What are your daily activities? Checking the alertlog file, backup status, performing any refreshes, resolving tickets and handling application team requests etc What is your typical day? Or What is the biggest problem you faced till now? Explain any one problem you faced during practise or any error you …

Read More »

ORACLE DATABASE RMAN INTERVIEW QUESTIONS

RMAN INTERVIEW QUESTIONS What are the advantages of RMAN? Validation of the backup Parallelism Block level backup Incremental backup Recovery catalog etc Explain how RMAN performs the backup? When RMAN is initiated, it will start reading datafile headers for used block information. It will get that from bitmap blocks With …

Read More »
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