Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    39

    Unanswered: refreshing test database using online db image

    Hi,

    I have a requirement of refreshing test database with the online backup of production ,also need to apply some log files ,Kindly help me for the same

    Do we need to use the redirected restore procedure ,if yes..After restore will the db be in rollforword pending state...

    Please provide the syntax for restore and appling the archive log files


    thanks

    with regads
    ashaq

  2. #2
    Join Date
    Jan 2003
    Posts
    4,294
    Provided Answers: 5
    Ashaq,

    To answer your questions:

    1) Redirected restore will be necessary if the directory structure of the DB of your test and production servers are different.

    2) Yes, they will be in rollforward pending

    3) The syntax depends on your particular setup. Read the manual for RESTORE and ROLLFORWARD (the Command Reference has these).

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •