Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011

    Unanswered: Restore releted information needed

    There is a full backup at Sunday, and at Monday 13:00, the log S0000100.log is saved to TSM. At Monday 14:00, database is crashed.

    Then DBA-1 restored the full backup of Sunday, and all archived logs till to S0000100.log to local hard disk (S0000101.log cannot be restored due to TSM issue).

    DBA-1 used “roll forward to end of logs and complete”, the database is up, the roll forward type is “end of logs”, but the data between 13:00 and 14:00 is lost.

    Now, DBA-2 want to know whether DBA-1 skipped any Logs during restore. How he can find ?

    [ NOTE : In history file it will give end of logs only ]
    Last edited by niteshtheone; 07-13-11 at 04:47.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    logfiles can NOT be skipped
    all available logfiles will be restored upto the point that is possible and which logfiles are available.
    best regards, Guy
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Aug 2001
    In the "List History rollforward" have you checked the Earliest Log and Current Log columns? Sorry, if you have already done it. I do not have access to DB2 to check it.

    What is the rollforward command used? Did the command use alternate log path option?

    As Guy says, it is not possible to skip logs files. You can ignore some after a Point In Time.


    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