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

    Red face Unanswered: Db2 restore understanding

    Hi,

    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/libtdpdb264.so 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-22.39.07.000000 UTC", because node "0" contains information later than the specified time.


    DATA1:

    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-22.39.07.000000 UTC

    DATA2:

    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
    Location
    Belgium
    Posts
    2,514
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Nov 2013
    Posts
    2
    Hi,

    Thanks a lot! , it works fine.

    SEEMTDB is NAME

    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
  •