DHTML Menu / JavaScript Menu Powered by Milonic
Already a member? Sign In

Village Journals help
Resonate your identity with Naseeb journals. Express your opinions, share your thoughts, post your writings and connect with like minded people through the power of expression.

Recover your database (Controlfile issues)


How will your recover your database when all control file corrupted or deleted.
----------------------------------- -----------------
Case#1
If you have mirrored copies of your control file do the following.
1. Copy all the existing control files at any different location just for the save side in case you massed with what you have.
2. Copy one of the good control file from the mirrored location to the corrupted location and start the database... simply no recovery needed!!

Case#2
If you have lost your all control files do the following.
You should have all the archived logs and online log available.
You have to recover the database by using backup control file.
1. rman
2. connect target /
3. connect catalog rmanowner/password@catalog (if available)
4. startup force nomount;
5. restore controlfile from autobackup;
6. alter database mount;
7. restore database;
8. recover database;
9. alter database open resetlogs;
After database started, take full backup again

Hopefully it will help!!
-Asif
 

Add Comments

 
Add