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 :

2 comments:

Raj said...

Hello Halim,
Link is not working, please update.

You can also create a new control file by "CREATE CONTROLFILE" Statement.

The Syntax is:

CREATE CONTROLFILE
SET DATABASE prod
LOGFILE GROUP 1 ('/u01/oracle/prod/redo01_01.log',
'/u01/oracle/prod/redo01_02.log'),
GROUP 2 ('/u01/oracle/prod/redo02_01.log',
'/u01/oracle/prod/redo02_02.log'),
GROUP 3 ('/u01/oracle/prod/redo03_01.log',
'/u01/oracle/prod/redo03_02.log')
RESETLOGS
DATAFILE '/u01/oracle/prod/system01.dbf' SIZE 3M,
'/u01/oracle/prod/rbs01.dbs' SIZE 5M,
'/u01/oracle/prod/users01.dbs' SIZE 5M,
'/u01/oracle/prod/temp01.dbs' SIZE 5M
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXLOGHISTORY 400
MAXDATAFILES 200
MAXINSTANCES 6
ARCHIVELOG;

Regards,
Raj
Stellar Oracle Recovery

Muhammad Abdul Halim said...

thanks RAJ .