Wednesday, October 8, 2014

Recovering control file

We can not start the database with out a control file, then how?
We can recover it as below:

-->connect to rman target
-->set dbid
-->startup nomount;
-->restore control file from autobackup;
-->alter database mount;
-->recover database;
-->Alter database open resetlogs;
(some times we face datafile errors while performing resetlogs)
Thats it..
Please take new complete backup again.
Alway keep controlfile autobackup ON

Thanks!

No comments:

Post a Comment