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:
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
thanks RAJ .
Post a Comment