Hello TSMers
AIX 6.1
TSM 6.2.2.0
I have been testing DR recovery using replicated DB backups and storage
pools, recovering to a second TSM instance on a remote server. I have
found that I cannot restore from every database backup.
I ran successful restores on Monday and Wednesday but today's restore
attempt failed. db2diag messages include
2011-09-22-09.24.36.455938-300 I1562137A367 LEVEL: Warning
PID : 17105122 TID : 2111 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 2111 EDUNAME: db2logmgr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogFile,
probe:4130
MESSAGE : Started retrieve for log file S0000223.LOG.
2011-09-22-09.24.36.456575-300 E1562505A576 LEVEL: Error
PID : 17105122 TID : 2111 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 2111 EDUNAME: db2logmgr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogDisk,
probe:3500
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "S0000223.LOG" could not be found.
DATA #1 : String, 110 bytes
This might mean that end-of-logs has been reached. Check for other
errors
to verify whether this is the case.
2011-09-22-09.24.36.457229-300 E1563082A434 LEVEL: Warning
PID : 17105122 TID : 2111 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000
EDUID : 2111 EDUNAME: db2logmgr (TSMDB1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveLogFile,
probe:4165
MESSAGE : ADM1847W Failed to retrieve log file "S0000223.LOG" on chain
"12" to
"/arclog/recovery/RstDbLog/".
2011-09-22-09.24.36.657930-300 I1563517A561 LEVEL: Error
PID : 17105122 TID : 10078 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-37 APPID: *LOCAL.tsminst1.110922142314
AUTHID : TSMINST1
EDUID : 10078 EDUNAME: db2redom (TSMDB1) 0
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1275
RETCODE : ZRC=0x071000D7=118489303=SQLP_EXT_NOT_IN_CHAIN
"This extent is not a successor of the previous extent. Fwd
Recovery can not continue."
I ran another DB backup, backed up devconfig, volhist, and ran prepare.
After waiting for the data to replicate to the remote site my restore
test was successful. The error messages I listed did not occur during
the successful restore attempt. There were no activity log messages
indicating an error during the first (unusable) DB backup. It appears
that I cannot recover from all of my DB backups and wonder if anybody
else has run across the same situation.
I'm trying to determine if the problem is mine or ours.
With confused and gracious desperation,
Jim Schneider
United Stationers
