Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2008
    Posts
    136

    Unanswered: how point-in-time recovery ?

    Hi All,
    Hope everyone is doing great as usual.

    Is there anyone who did point-in-time recovery of database.
    Please provide the steps for doing this?
    Its must to know for me .....I am working with Bank thats.

    Please reply ASAP

    Thanks
    Pawan
    Regards
    Pawan Kumar

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Did you bother to read the DB2 manual? Recovery is described there along with all the parameters.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2008
    Posts
    136
    I read the manual and did accordingly but not able to find desired output

    I followed the below steps....

    db2 backup database test online to /home/backup/ include logs
    db2 restore database test from /home/backup/ into tltest without prompting

    and then move the logs of test db to log path of tltest db,then

    rollforward database tltest to 2008-06-12-22.30.56.000000 and complete

    on executing below command facing below error

    SQL1275N The stoptime passed to roll-forward must be greater than or equal to
    "2008-06-17-17.00.15.000000", because database "TLTEST" on node(s) "0"
    contains information later than the specified time.

    when I execute below command ...its run successfully

    rollforward database tltest to 2008-06-17-17.00.15.000000 and complete

    but I want to data recovery till 2008-06-12-22.30.56.000000 How I can do this?
    What I need to follow ?
    Regards
    Pawan Kumar

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Obviously, rollforward can only apply logs that are forward in time related to the backup. In order to recover the database to 2008-06-12-22.30.56 you need a backup taken before that time and all logs in between.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Mar 2008
    Posts
    136
    done successfully
    thanks
    Regards
    Pawan Kumar

Posting Permissions

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