B&R Control File restore.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: B&R Control File restore.

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Friends...

    Imagine the folowing scenario over a 5 day period.

    Day 1 - Full online database backup
    Day 3 - Alter Tablespace TSPACE1 add datafile / Perform full online backup afterwards.
    Day 5 - Media Failure, requires restore/recovery for TSPACE 1.

    Question..

    When the restore/recovery takes place - should the control file backup up on day 1 be used or the control file backup up on day 3 ?

    If the control file from day 1 is used.. is the ddl used to create extra datafile included in archive logs thus making the control file current (including added datafile on day 3) at the end of complete recovery.

    Thanks

    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    Originally posted by Sureshy
    Hi Friends...

    Imagine the folowing scenario over a 5 day period.

    Day 1 - Full online database backup
    Day 3 - Alter Tablespace TSPACE1 add datafile / Perform full online backup afterwards.
    Day 5 - Media Failure, requires restore/recovery for TSPACE 1.

    Question..

    When the restore/recovery takes place - should the control file backup up on day 1 be used or the control file backup up on day 3 ?

    If the control file from day 1 is used.. is the ddl used to create extra datafile included in archive logs thus making the control file current (including added datafile on day 3) at the end of complete recovery.

    Thanks

    Suresh
    Hi Suresh!

    You need not to use a backuped control file. The new datafile is recorded in the actual controlfile. But you have to replace the datafiles of TSPACE1 with the backuped files from day 3 and the archived redologs.

    Thanks

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Mageri..

    Thanks for your reply.

    Does that mean that when the archived logs are applied from day 1, the ddl will be in them to create the new datafile in day 3's archive logs, also updating the control file ?

    Thanks
    Suresh
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    Hi,
    The archived logs will be applied from where the point the restore has been done. If you've done a restore from the day 3 , then only the logs from that point will be applied. This means that your restore already contains the datafile for the new tablespace. Only the ddls will have needed to be applied.


    Cheers
    Vinit
    Vinit

  5. #5
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    Originally posted by Sureshy
    Hi Mageri..

    Thanks for your reply.

    Does that mean that when the archived logs are applied from day 1, the ddl will be in them to create the new datafile in day 3's archive logs, also updating the control file ?

    Thanks
    Suresh
    You only needs the archived logs since last hot backup, from day 3, for recovery.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    You only needs the archived logs since last hot backup, from day 3, for recovery.
    Some DBAs prefer to keep all archived logs since DB creation (for one reason or another).


  7. #7
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Is there any reason to keep archive logs if the backup sets that use them are not also kept?
    David Knight
    OCP DBA 8i, 9i, 10g

  8. #8
    Join Date
    Oct 2000
    Posts
    467
    Hi,
    Maybe..if the latest sets of backup are corrupted and you need to go to the one taken before. Comes in handy

    Cheers
    Vinit
    Vinit

  9. #9
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    But suppose that 7 (for the sake of discussion) backups are kept.

    Archive logfiles applicable to backups earlier than those 7 are worthless and should be deleted.
    David Knight
    OCP DBA 8i, 9i, 10g

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