Troubleshooting
Problem
ROLLFORWARD ASKS FOR MORE LOGS THAT ARE NOT INCLUDED IN THE ONLINE BACKUP IMAGE
Symptom
Restore of an online backup with includes logs (using logtarget) requires more logs during rollforward phase.
First log archive method (LOGARCHMETH1) = TSM
The specific error is as following :
on source
db2 backup db XXXX online to . compress
(backup image included only log file S0000769.LOG and S0000770.LOG)
on target:
$ db2 restore db XXXX from . taken at 20160719201529 on
/data/db2/data/vol1,
/data/db2/data/vol2/
dbpath on /data/db2/dbpath
logtarget /data/db2/logs
newlogpath /data/db2/logs/
SQL2539W The specified name of the backup image to restore is
the same as the name of the target database. Restoring to an
existing database that is the same as the backup image database
will cause the current database to be overwritten by the backup
version.
Do you want to continue ? (y/n) y
DB20000I The RESTORE DATABASE command completed successfully.
$ db2 rollforward db XXXX to end of backup and complete
overflow log path "(/data/db2/logs/EBU500)"
SQL1268N Rollforward recovery processing has stopped because
of error "SQL2033" while retrieving log file "S0000771.LOG" for
database "XXXX" on database partition "0" and log stream "0".
(RF requires additional "S0000771.LOG" )
First log archive method (LOGARCHMETH1) = TSM
The specific error is as following :
on source
db2 backup db XXXX online to . compress
(backup image included only log file S0000769.LOG and S0000770.LOG)
on target:
$ db2 restore db XXXX from . taken at 20160719201529 on
/data/db2/data/vol1,
/data/db2/data/vol2/
dbpath on /data/db2/dbpath
logtarget /data/db2/logs
newlogpath /data/db2/logs/
SQL2539W The specified name of the backup image to restore is
the same as the name of the target database. Restoring to an
existing database that is the same as the backup image database
will cause the current database to be overwritten by the backup
version.
Do you want to continue ? (y/n) y
DB20000I The RESTORE DATABASE command completed successfully.
$ db2 rollforward db XXXX to end of backup and complete
overflow log path "(/data/db2/logs/EBU500)"
SQL1268N Rollforward recovery processing has stopped because
of error "SQL2033" while retrieving log file "S0000771.LOG" for
database "XXXX" on database partition "0" and log stream "0".
(RF requires additional "S0000771.LOG" )
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Recovery - Rollforward","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
swg21989608