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
----------------------------------- -----------------
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


