Recovery while control file is old one

Asked By 10 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #101530

Recovery while control file is old one

qa-featured

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.

 

Login/Register to Answer

Related Questions