Home / Oracle DBA / STEPS FOR ORACLE CONTROFILE COMPLETE RECOVERY

STEPS FOR ORACLE CONTROFILE 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> shutdown immediate

[oracle@server1 ~]$ gotoudump location and copy the first create controlfile script to a file called control.sql
SQL> startup nomount
SQL> @control.sql
SQL> alter database open;
Note: After creating control files using above procedure, there will be no SCN in that. So server process will write the latest SCN to control files in this situation by taking info from datafile header.
Note: we will perform until time recovery in case we lost a single table and need to recover it. But to do this we need to have approval from all the users in the database.
control file complete recovery
View More:
ORACLE DATABASE RMAN INTERVIEW QUESTIONS
ORACLE BACKUP and RECOVERY INTERVIEW QUESTIONS
ORACLE EXP/IMP &DATAPUMP 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