the strategy for tesing backup files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: the strategy for tesing backup files

  1. #1
    Join Date
    Aug 2001
    Posts
    3

    Smile

    Hi,

    My question is what the strategy is for tesing backup files?

    Thanks in advance!
    rzhao

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    this is dependent on
    (1) availability of the database.
    (2) tolerance level
    (3) size of the database
    (4) maintenance staff availability

    tell us about to discuss further.
    sonofsita
    http://www.ordba.net

  3. #3
    Join Date
    Apr 2001
    Posts
    219
    The strategy should be based on your SLA and/or back up and recovery plan. These plans should cover all the back up and recovery senarios that your customer wants you to plan for. Then test these plans on development machines or borrow hardware from a vendor similar to what you have and test away!
    ______________________
    Applications come and go,
    but the data remains!

  4. #4
    Join Date
    Aug 2001
    Posts
    3

    more details

    Here we are:

    Thank you for your replies!

    We have a 7x24 production db on solaris and we backup db by rman. I'd like to test all the cold&hot backup files on the same box if possible and not very difficult. Other wise different box is OK. What is procedure step by step ?

    Thanks again!
    rzhao

  5. #5
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    do not test on the production database.
    start with a crash during hot backup by disconnecting power and then reconnecting. Then try all senarios possible like deleting temp, rbs, data, index files and then restroing them using backup files. as u r using rman for backup recover using rman. that gives hands on experience to u.i think u know where the rman scripts r located.use them.
    also play with deleting one archived log file which is required for recovery, and also try by deleting online redo logs.
    try disaster recovery senario also.. all this u do using rman only.
    sonofsita
    http://www.ordba.net

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Think September 11.

    The biggest mistake people make in testing backup/recovery scenarios is that they never fully test and DOCUMENT how to recover in the event of a disaster. Test all recovery scenarios completely before you say "done".
    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