RECOVERY SCENARIO
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RECOVERY SCENARIO

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    A clarification please...

    Consider the following scenario... I have a offline complete backup taken on Sunday. the other days of the week I have taken online backup.

    Now if my whole system crashes on Thursay, how do I recover?

    If I restore the offline backup of Sunday, I loose 3-4 days of data in the database.

    How can I utilize the online backup that I have taken till Wednesday?

    Thanks.

  2. #2
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Backup

    Hi

    So you have 2 options :

    1) Restore Sundays backup and then apply arch. logs then u can get ur database in consistent state.

    2) If alongwith online backups u hv taken control file backup also then restire online backup alngwith control file and then apply arch files and u'll have the database up.


    If someone have different views pls. post.
    --------------------------
    The Time has come ....

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