再做回滚时,提示如下错误:
db2 "rollforward db db97 to end of logs overflow log path (/db2arch/log_dir)"
[db2inst1@db2v97 /db2arch/log_dir]$ls
S0000040.LOG S0000041.LOG S0000042.LOG S0000043.LOG
[db2inst1@db2v97 /db2arch/log_dir]$db2 rollforward db db97 query status
Rollforward Status
Input database alias = db97
Number of nodes have returned status = 1
Node number = 0
Rollforward status = DB pending
Next log file to be read = S0000040.LOG
Log files processed = -
Last committed transaction = 2013-12-02-05.04.41.000000 UTC
[db2inst1@db2v97 /db2arch/log_dir]$flow log path (/db2arch/log_dir)" <
SQL4970N Roll-forward recovery on database "DB97" cannot reach the specified
stop point (end-of-log or point-in-time) on database partition(s) "0".
Roll-forward recovery processing has halted on log file "S0000043.LOG".
[db2inst1@db2v97 /db2arch/log_dir]$db2 rollforward db db97 query status
Rollforward Status
Input database alias = db97
Number of nodes have returned status = 1
Node number = 0
Rollforward status = DB working
Next log file to be read = S0000043.LOG
Log files processed = S0000040.LOG - S0000041.LOG
Last committed transaction = 2013-12-02-05.04.41.000000 UTC
请问为什么会出现这种情况?
Next log file to be read = S0000043.LOG
Log files processed = S0000040.LOG - S0000041.LOG中间隔了42
收起