Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: rollforward question?

    I am working with db2v7 and aix 4.3.3 .
    I am going to restore from online backup that has been taken on july 29 , how can I found out which logs file I should use for rollforwarding and what is the sql command for rollforwarding.
    thank you in advance for your help.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2 list history backup since 20040709 for database <dbname>

    The output will show the 'first log file' you will need ....

    Then you'll have to get all the logs since then for the rollforward to succeed ...

    For the command, have a look in the command reference or google for 'db2 rollforward database'

    Here's an example
    rollforward database sample to end of logs and complete

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by sathyaram_s
    db2 list history backup since 20040709 for database <dbname>

    The output will show the 'first log file' you will need ....

    Then you'll have to get all the logs since then for the rollforward to succeed ...

    For the command, have a look in the command reference or google for 'db2 rollforward database'

    Here's an example
    rollforward database sample to end of logs and complete

    HTH

    Sathyaram
    Hi Sathyaram,
    let me I explaine more detail the senerio is

    step1 :
    1-I update tab1 set col1= xx and created table xx
    2- I took online backup timestamp = xxxxxxxxxx
    step2 :
    1- I update tab1 set col2= YY and created table YY
    2- I took online backup timestamp = YYYYYYYYYYY
    step3 :
    1- I update tab1 set col3= ZZ and created table ZZ
    2- I took online backup timestamp = ZZZZZZZZZZZZ
    I did ftp backp image YYYYYYYYYY and log file to another box and restored to database
    as you told me when I rollforwarded form S000000004.LOG (I retrevied form history) by the end of log S00000009.log I have all updated from step 3!!!!!!
    I do not want that I need just updated to end of step2.
    Please help. thanks

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Then you need to do point in time recovery ...

    ROLLFORWARD DATABASE dbname to <iso-time> and complete

    The iso time should be atleast the 'end-time' of the backup in step2 ...

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by sathyaram_s
    Then you need to do point in time recovery ...

    ROLLFORWARD DATABASE dbname to <iso-time> and complete

    The iso time should be atleast the 'end-time' of the backup in step2 ...

    HTH

    Sathyaram
    Thank you so much for your help Sathyaram

Posting Permissions

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