Can you use a binary backup of controlfile to recover a db

Are you sure you are recovering a database? You have deleted the control file but that was all you did, you have not lose a single datafile. So basically this is:

Have not backed up the control file using the TO TRACE option, but used the TO filename option of ALTER DATABASE BACKUP CONTROLFILE

you do

Use the control file copy to obtain SQL output. Copy the backup control file and execute STARTUP MOUNT before ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS. If the control file copy predated a recent structural change, edit the TO TRACE output to reflect the structural change

This is cut & pasted from Oracle Docs

Thank you very much!
You said: "This is cut & pasted from Oracle Docs"

Could you please tell me which chapter? I would like to read the details!

Thanks a lot! So, the conclusion is that you cannot use the binary backup of the controlfile directly to recover the db. You have to use it to create a trace file and then use that trace file to build a new control file, then continue the recovery. (In my scenario, there is no recovery required. It simply is a scenario of lossing all current control files.)

Could you please tell me which chapter? I would like to read the details!

Hi abonga can you do this...
......
startup mount
select * from v$recover_file; (note down the file name and #)
alter database recover datafile file#
(will ask for archive files/redofiles)
auto
alter database open;(if you get error user alter database open using backup controlfile)
.....
Hope this work.
can you post the result.
Thanks.
Thanigaivasan.

Sorry, I typed your name wrongly Abongwa.
Thanigaivasan

Here is the doc that explain ALL:

http://otn.oracle.com/docs/products/...scen.htm#11872

See the topic of Table 6-1 Options for Creating the Control File


I think that's the ONLY right way to use a binary backup of controlfile. All other use is useless. :>

Ur right Narayanan. Get the current logfile from v$log, and then apply that logfile with the exact path.
First , give this command,
Recover database using backup controlfile. It asks for the recovery of the database with a particular file. Just supply the file name which is a current one. Then u get a message like
'Media Recovery Complete'

Now open database with resetlogs.

best of luck

tia

I felt like sharing this....site..
http://metalink.oracle.com/metalink/...1&p_showHelp=1


Thanks.
Thanigaivasan

Hi Abongwa,

When you are trying to recover the database with 'ALTER DATABASE RECOVER UNTIL CANCEL USING BACKUP CONTROLFILE' ... this is an incomplete recovery.
To do this, you should copy all the datafiles from sufficiently recent backup (the files should correspond to the structure of your database when you backed up your control file).
Then perform the recovery with the above command.
When you are prompted for the current log sequence number, then cancel the recovery.
Then use the command 'ALTER DATABASE OPEN RESETLOGS' to open the database.

Hope you'll succeed with this

I dont understand why you peeps are insisting on applying logs when there is nothing to recover heh

Hi,

I totally agree with Pando.

He has only deleted the Controlfile. Which means that all the datafiles and the logfiles are intact.
Just recreate the controlfile and open the database normally.


Vijay.