How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?

Questions by guddasantu

Showing Answers 1 - 5 of 5 Answers

Kunal Mishra

  • Oct 31st, 2007
 

If there is no backup of control file, then recreate the control file and specify name, location and size of all datafiles, redolog files and controlfiles in script, on the behalf of this you can resolve the scenario

  Was this answer useful?  Yes

hemantocp

  • Sep 9th, 2008
 

We can create the controlfile, while recreating controlfile specify the REUSE oprtion and if having all the Logfiles intact then use norestlogs option while creating the Control file than specify the name of all the datafiles and logfiles and issue the startup nomount command, then run the script to craete a controlfile. The script must have all necessery info.

  Was this answer useful?  Yes

rharijan

  • Sep 2nd, 2009
 

If controlfile is lost we can go to the trace file in udump and there after we can create control file by copying the datafile and redologfile and paste in user managed backup by giving old location to a new new location and then try to recover the old one giving the reuse option.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions