Results 1 to 4 of 4

Thread: Crash recovery

  1. #1
    Join Date
    Dec 2015
    Posts
    3

    Question Unanswered: Crash recovery

    How to apply crash recovery when one of the log file missing???

  2. #2
    Join Date
    Jul 2016
    Location
    Germany
    Posts
    32
    Provided Answers: 2

    quick and dirty

    Hi saiteja09,

    in Case of a missing log, you lost all db-changes that took place after the beginning of that log.
    So you can restore the last backup and rollforward to a point in time before the lost log,
    or you let the recover crash and give it a rollforward complete.

    Good luck
    db2dp

  3. #3
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    111
    Provided Answers: 13
    You can open a PMR with IBM.
    They can provide you some way to bring the database online, but you will have to export all the date afterwards.
    And nobody can guarantee the data consistency of course...
    Regards,
    Mark.

  4. #4
    Join Date
    Aug 2016
    Posts
    1
    Quote Originally Posted by db2dp View Post
    Hi saiteja09,

    in Case of a missing log, you lost all db-changes that took place after the beginning of that log.
    So you can restore the last backup and rollforward to a point in time before the lost log,
    or you let the recover crash and give it a rollforward complete.

    Good luck
    db2dp
    I'm not sure I understand. Everything after the last log is gone?

Posting Permissions

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