一台机器的3个节点的多分区,
下面是相信过程。版本10.5
db2_all "<<+0 < db2 restore db dpfdb from ~/dbback taken at 20160225141524 logtarget ~/dpflogs"
DB20000I The RESTORE DATABASE command completed successfully.
db2 restore db dpfdb ... completed ok
$db2_all "<<-0 < db2 restore db dpfdb from ~/dbback taken at 20160225141524 logtarget ~/dpflogs"
rah omitting logical node 0
DB20000I The RESTORE DATABASE command completed successfully.
db2 restore db dpfdb ... completed ok
DB20000I The RESTORE DATABASE command completed successfully.
db2 restore db dpfdb ... completed ok
db2 "rollforward db dpfdb to end of backup on all dbpartitionnums and stop overflow log path(/var/db2a/dpflogs)"
SQL1268N Rollforward recovery processing has stopped because of error
"118489302" while retrieving log file "S0000001.LOG" for database "DPFDB" on
database partition "0" and log stream "".
$db2 connect to dpfdb
SQL1117N A connection to or activation of database "DPFDB" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019
但是下面查询状态没有处于pending呀????百思不得解
$db2 rollforward db dpfdb query status
Rollforward Status
Input database alias = dpfdb
Number of members have returned status = 3
Member ID Rollforward Next log Log files processed Last committed transaction
status to be read
----------- -------------------------- ------------------- ------------------------- --------------------------
0 DB working S0000001.LOG S0000000.LOG-S0000000.LOG 2016-02-25-06.15.27.000000 UTC
1 DB working S0000001.LOG S0000000.LOG-S0000000.LOG 2016-02-25-06.15.24.000000 UTC
2 DB working S0000001.LOG S0000000.LOG-S0000000.LOG 2016-02-25-06.15.24.000000 UTC
db2 "rollforward db dpfdb to end of logs on all dbpartitionnums and stop overflow log path(/var/db2a/dpflogs)"
db2ckbkp -a DPFDB.0.db2a.DBPART000.20160225141524.001 |grep -i "File Number"
File Number [000] = 0
File Number [001] = 1
db2ckbkp -a DPFDB.0.db2a.DBPART002.20160225141524.001 |grep -i "File Number"
File Number [000] = 0
File Number [001] = 1
前滚需要的日志0,1 在/var/db2a/dpflogs路径下都有呀
到底错误在哪里呢?想了半天,没整明白
收起