Recovery from Cold Backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Recovery from Cold Backup

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    Recovery from Cold Backup

    Hi

    We have a complete cold Backup taken on Sunday. The database crashed on wednesday. None of the database files are available. The only files we have are the taped backup archive files till wednesday.

    Is there a possibility of recovering the database until the recent archive which we have in the tape using the cold backup...

    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yes, if you have all the archive logs since the cold backup then you can recover to your last log

  3. #3
    Join Date
    Aug 2002
    Posts
    176
    thanks for your reply.
    But How do we proceed with the recovery when all the datafiles are missing including the contrrol file. All we have is the control file taken as a backup with the cold backup
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  4. #4
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    You can still recover with your backup controlfile. I'm assuming here that you've lost your redologs, controfiles, and datafiles:

    1) Restore all backup datafiles, and controlfile. Also restore the password file and init.ora if you lost those too. Don't restore your redo logs if you backed them up.

    2) Make sure that ORACLE_SID is set to the database you want to recover

    3)startup mount;

    4)recover database using backup controlfile;

    At this point Oracle should start applying all your archive logs, assuming that they're in log_archive_dest

    5)alter database open resetlogs;

    6) TAKE A FULL BACKUP!

    HTH

    Good Luck!

    Austin

  5. #5
    Join Date
    Aug 2002
    Posts
    176
    Bingo , You got it .

    Yes it worked perfect . Thanks a lot..
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

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