互联网服务Db2数据库

SQL1268N错误,折磨疯了的错误

一台机器的3个节点的多分区,下面是相信过程。版本10.5db2_all "显示全部

一台机器的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路径下都有呀

到底错误在哪里呢?想了半天,没整明白

收起
参与6

查看其它 1 个回答zss0109211的回答

zss0109211zss0109211数据库管理员null

error\"118489302\" while retrieving log file \"S0000001.LOG\"

互联网服务 · 2016-03-03
浏览2014

回答者

zss0109211
数据库管理员null

zss0109211 最近回答过的问题

回答状态

  • 发布时间:2016-03-03
  • 关注会员:3 人
  • 回答浏览:2014
  • X社区推广