Can you use a binary backup of controlfile to recover a db - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

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

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  2. #12
    Join Date
    Feb 2002
    Posts
    59
    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!




  3. #13
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.

  4. #14
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Sorry, I typed your name wrongly Abongwa.
    Thanigaivasan

  5. #15
    Join Date
    Feb 2002
    Posts
    59
    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. :>

  6. #16
    Join Date
    Apr 2002
    Posts
    291
    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
    PNRDBA

  7. #17
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    I felt like sharing this....site..
    http://metalink.oracle.com/metalink/...1&p_showHelp=1


    Thanks.
    Thanigaivasan

  8. #18
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    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

  9. #19
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont understand why you peeps are insisting on applying logs when there is nothing to recover heh

  10. #20
    Join Date
    Mar 2002
    Posts
    301
    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.
    Say No To Plastics

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width