Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    10

    Unanswered: Online backup Rollforward error

    Db2 7.1 FP10

    I am using an online backup to restore a live database onto a development machine. The restore has been sucessfull, but I am having problems with the roll forward.

    Because an online backup was used, log files were not captured. I have copied ALL log files in the production dir to my development server.

    "rollforward db JDS_LIVE stop" results in the following error:

    Database "JDS_LIVE" cannot be brought out of roll forward pending state until roll-forward has passed a point in time greater than or equal to "2004-03-31-04.32.53.000000", because node "0" contains information later than the specified time

    My online backup has a time stamp of 20040330230004

    Obviously coming from a production server, I have logfiles dated before and after both of the quoted date/times. I have tried many combinations of log files before / after both dates, but get the same error.

    The log files from what date range should I be including in the rollforward ..... Or am I doing something else wrong

    Cam

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513

    Re: Online backup Rollforward error

    Originally posted by JDCam


    The log files from what date range should I be including in the rollforward ..... Or am I doing something else wrong

    Cam
    On the production machine, do a "LIST HISTORY BACKUP ALL FOR <dbname>".

    That will tell you what log files are needed (Earliest-Current).
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Feb 2004
    Posts
    10
    My appologies ... I am learning as I go here

    I have done the list history command as you instruct. Under the entry matching the Online backup I am using I see the files identified as:
    Earliest: S0000259.log
    Current: S0000261.log

    I have copied the 3 files 259,260 and 261 to the log directory on the test machine (no other log files there). I reran the same statement and received the same error message as before.

    Is it just the files from this particular online backup I need to worry about, or anything before or after it. ? Is it all files since the last Offline backup ??

    Cam

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Originally posted by JDCam
    My appologies ... I am learning as I go here

    I have done the list history command as you instruct. Under the entry matching the Online backup I am using I see the files identified as:
    Earliest: S0000259.log
    Current: S0000261.log

    I have copied the 3 files 259,260 and 261 to the log directory on the test machine (no other log files there). I reran the same statement and received the same error message as before.

    Is it just the files from this particular online backup I need to worry about, or anything before or after it. ? Is it all files since the last Offline backup ??

    Cam
    No, those should be enough to get it consistent.

    Is this what you're issuing?
    ROLLFORWARD DATABASE <dbname> TO END OF LOGS AND STOP

    If so, try add OVERFLOW LOG PATH pointing to the directory where the logs are, maybe there's some mix-up there.
    --
    Jonathan Petruk
    DB2 Database Consultant

  5. #5
    Join Date
    Feb 2004
    Posts
    10
    It has completed sucessfully !!

    I was using:
    rollforward db JDS_LIVE stop

    As per your message I tried again using:
    rollforward db JDS_LIVE to end of logs and stop

    That seemed to do the trick

    Thanks !!

  6. #6
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Originally posted by JDCam
    It has completed sucessfully !!

    I was using:
    rollforward db JDS_LIVE stop

    As per your message I tried again using:
    rollforward db JDS_LIVE to end of logs and stop

    That seemed to do the trick

    Thanks !!
    Oops, I should have caught that from the start...
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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