Showing posts with label sql server. Show all posts
Showing posts with label sql server. Show all posts

Monday, August 1, 2011

How can recover database after deleting/corrupted all control files in oracle .

If you have previously issued ALTER DATABASE BACKUP CONTROLFILE TO TRACE then use that file and modify.

If you don't have any backup of controlfile then you have to create a new one as below.

Try to use _allow_resetlogs_corruption = true parameter. and after open database , export the database and rebuild it .

you can follow this steps after deleting of active redolog file or all redolog files ;

see more here :