Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013

    Red face Unanswered: Db2 restore understanding


    can anybody explanin this issue?

    I do a full restore from an online backup.

    > db2 restore db NAME load /opt/tivoli/tsm/tdp_r3/db264/ taken at 20131115233813
    DB20000I The RESTORE DATABASE command completed successfully.

    Backup time 15:23

    > db2 rollforward db NAME to end of backup and complete ;
    SQL1273N An operation reading the logs on database "SEEMTDB" cannot continue because of a missing log file "S0000077.LOG" on database partition "0" and log stream "0".

    rollforward need S000077.log no problem

    but S0000077.LOG is archived 17:37 same day. The log is older than the backup? and I don`t understand why i need this log. The DB is without this log broken.

    Versuch1: db2 rollforward db NAME stop
    SQL1276N Database "NAME" cannot be brought out of rollforward pending state until roll-forward has passed a point in time greater than or equal to "2013-11-15- UTC", because node "0" contains information later than the specified time.


    db2 rollforward db NAME query status
    Rollforward Status
    Input database alias = NAME
    Number of members have returned status = 1
    Member ID = 0
    Rollforward status = DB working
    Next log file to be read = S0000077.LOG
    Log files processed = -
    Last committed transaction = 2013-11-15- UTC


    BKI8807I: Archive log file 'S0000077.LOG' of chain 'C0000000'.
    BKI0057I: Time: 11/15/2013 05:37:19 PM Object: /:db2fxd.NAME.NODE0000.20131115173707.C0000000_S000 0077.LOG with: 4104.

    Thanks, thom7421

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    what has this db SEEMTDB todo with NAME ?
    if logs are included in backup (default) they can be extracted with option logpath or logs
    the path should be empty
    execute rollforward .. overflow log path ....."this path"
    hope this will help
    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
    Nov 2013

    Thanks a lot! , it works fine.


    greetings, thom7421

Tags for this Thread

Posting Permissions

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