Recover from cold backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Recover from cold backup

  1. #1
    Join Date
    Nov 2001
    Posts
    11
    Has anyone tried to recover the database with a full offline backup and all the archived logs? Assume you have all the needed old files (datafile,control file...) and have lost all your current files except those archived logs. I know how to recover from hot backup, but for this one...

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2001
    Posts
    11
    Hi Jeff,

    Thanks for the help.
    Just want to confirm that the control file used in the scenario (from Metalink) is the old control file backed up at OS level, because I assume I cann't access the current database to create a up-to-date backup control file should there be some kind of fatal failure.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yup, the backup controlfile is actually the current controlfile. You use it as a backup controlfile so you can apply your archived redo logs.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Nov 2001
    Posts
    11
    Which means if I lost all the current files ( incl control file), I will not be able to recover the database using cold backup files plus archived logs, am I right? Can I restore all the datafile, create a new controle file ( using script from 'backup controlfile to trace' taken at cold backup time), and roll forward through all the archived logs? Every tried?

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That's a different story. First, you need to create your controlfile. You can do this from a trace file. Check out http://metalink.oracle.com/metalink/...p_id=1014504.6 for details.

    Once you have created your "backup controlfile", you can now recover through your last archived redo log file.

    Unfortunately, I've done this dozens of times...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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