> 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.
db2 rollforward db NAME query 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
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