Recover using backup controlfile

[seelan]

Hi all,

Disk which contains all of my controlfile got corrupted.

Steps Followed
---------------

1) Shutdown the database
2) Copied the yesterday controlfile binary backup to init.ora control fie location
3) startup mount
4) recover datbase using backup controlfile(Selected auto option. It applied all the archive log files)
5) alter database open reselogs;

Now getting the following error


alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:

Please guide me how to reover my database in this situation.

Thanks,
Seelan

[seelan]

Hi,

Again I issued the command

recover database using backup controlfile;


it was asking for non existent archive log file

I have pasted the one logile from each group and media recovery got completed.

Now the datbase is up

Seelan

[KenEwald]

Nice job Seelan.

[ixion]

Since your DB is now up.

Issue the following: alter database backup controlfile to trace;
Next look at the udump trace file that is created....

You didn't have to do "alter database open resetlogs"....