Hi
If all control file have been corrupted and we have a binary file old backup of control file which is taken 10 hrs before.
In this condition which type of recovery is possible.
Thanks
You can Create the Control Files if you have datafiles.
There are some steps you need to follow in order to restore the database.
1. Startup without mount
SQL > startup nomount
2. Check the path of Control File
SQL > show parameter control
3. Create the Control File
SQL > CREATE CONTROLFILE REUSE DATABASE "ORCLE10G" RESETLOGS NOARCHIVELOG
MAXLOGFILES 14
MAXLOGMEMBERS 2
MAXDATAFILES 104
MAXINSTANCES 44
MAXLOGHISTORY 224
LOGFILE
GROUP 1 'K:ORCLE10GLOGREDO02.LOG' SIZE 50M,
GROUP 2 'K:ORCLE10GLOGREDO07.LOG' SIZE 90M,
GROUP 3 'K:ORCLE10GLOGREDO09.LOG' SIZE 50M
DATAFILE
'K:ORCLE10GDATASYST1.DBF',
'K:ORCLE10GDATAUNDS01.DBF',
'K:ORCLE10GDATASYSAX01.DBF',
'K:ORCLE10GDATAUS01.DBF',
'K:ORCLE10GDATAEXLE01.DBF',
'K:ORCLE10GDATAUND2.DBF'
CHARACTER SET WE8MSWIN1252;
4. Mount the Database
SQL > alter database mount;
5. If the database mounted successfully. Open the database with resetlogs option.
SQL > alter database open resetlogs;
If you get a message “Database Altered”, you are successful.
Please let us know your experience.
