互联网服务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 个回答disizhishou的回答

disizhishoudisizhishou研发工程师IBM

最好把对应db2diag.log贴出来。 能确定/var/db2a/dpflogs下面的日志文件是restore时候产生的吗? 我看restore命令指定的logtarget是 ~/dpflogs,不是/var/db2a/dpflogs。

note:

118489302=SQLP_EXT_DBID_INCORR 
= \"Database ID does not match Extent probably for another 
database.\" 

软件开发 · 2016-03-03
浏览2491

回答者

disizhishou
研发工程师IBM

disizhishou 最近回答过的问题

回答状态

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