full db recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: full db recovery

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    full db recovery

    Hi Friends,

    OS - aix 4.3.2
    db - oracle 8.1.5

    We encountered a disk failure/crash in our database. We can't salvage
    the data on the disk anymore, and eventually the entire disk where
    the oracle_home and dbf reside was replaced. This happened on friday
    evening. The db was in archive log mode, we do cold backup on
    Sundays, and take daily backup of the archive logs (mon. thru sat.)
    as what the backup/recovery docs suggest.
    Following the recovery procedure, we reinstall the rdbms following
    the same filesystem name and directories. Then we restore the cold
    backup from 4mm tape to the target directories. We can now startup
    the database from the previous Sunday backup. My problem is how to apply the backed-up archived logs from monday - friday? I've tried reading the recovery docs but it does not clearly explain the steps
    or I was just a little dumb to understand it.

    Please Help.
    Thanks you

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Last edited by jovery; 06-23-2003 at 09:30 AM.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks my friend. ....

    You know, before posting here, I tried issueing the
    command:
    svrmgrl> recover database until cancel;

    it returns an error and tells me to use backup controlfile;
    and I am wondering if it is referring to the control file that
    is backed up using "alter system backup controlfile to trace or
    " or the control file that is backed-up using os copy.

    BTW, is the control file that is an output to
    "alter system backup controlfile to " can be used also?

    Thanks again....:}

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The controlfile is the one that was backed up during your normal cold backup.

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    Kris,

    I believe you backed up your controlfile (binary copy) when you cold backuped your datafiles on sundays. For doing this the command is ALTER DATABASE BACKUP CONTROLFILE TO 'file';

    When you restored the db, you should have placed the backuped datafiles in original place and the backuped controlfile as well. Then, startup mount and do RECOVER DATABASE USING BACKUP CONTROLFILE;

    F.

  6. #6
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Thanks Mnem....:}

    Actually I made two (2) types of control file backup.
    One, user "os copy" command and the other using
    "ALTER DATABASE BACKUP CONTROLFILE TO 'file';"

    What's the difference between the two?

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