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

    Unanswered: rollforward question

    we are using db2v7.2 fix pack 6 aix 5.2
    every night we start online backup at 9 PM and it finished at 11:30 PM, at the same time we are running a application , if for any reason the application failed at 10:20 PM during the onlinbackup, how can I recover the data?

    Thank you in advance for your help .

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I guess you'll need to restore from the previous day's backup and then rollforward to the point of failure as usual.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Say, the appl fails today, ie 21 Jan 2005 at 1020 pm ... You started the online backup at 9 pm and it does not finish until 1130 pm

    In this case, you'll have to use yesterday's backup and roll the db forward to a PIT needed ..

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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    oops .. n_i posted just a moment before I did ... Mine is 'redundant' post
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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