|
工作的地方不方便上网,回复晚了些,抱歉.
数据库备份的有效性按照你说的我查了一下,备份的信息都列出来了,buffers processed: #####这一段时间太长了,没有等到出结果我就终止掉了.
备份应该没有什么问题.
备份: db2 backup database xxx to /file compress without prompting, 做的是离线全备份,应用都停掉做的.
恢复脚本:
. /home/psoft8/sqllib/db2profile
db2 "RESTORE DATABASE FS90PRD FROM /file01/file02 TAKEN AT 20090614170540 TO /file03/ INTO FS90PRD redirect WITHOUT PROMPTING"
...
db2 "SET TABLESPACE CONTAINERS FOR 19 USING (FILE '/xxxx/xxx/xxxx/xxxx/xxxxxx.DBF' 30000)"
...
db2 "RESTORE DATABASE FS90PRD CONTINUE"
db2 "ROLLFORWARD DATABASE FS90PRD STOP"
中间SET TABLESPACE CONTAINERS的那段略掉了.
db2diag.log 我已经查过了.
因为 (FFFF EBDF 就是 -5153) (SQL2038N A database system error "-5153" occurred during processing.)
所以我感觉就是下面这段报的错误.
2009-06-15-12.49.41.075815+480 I80111951A523 LEVEL: Error
PID : 1204454 TID : 1 PROC : db2agent (FS90PRD) 0
INSTANCE: psoft8 NODE : 000 DB : FS90PRD
APPHDL : 0-1186 APPID: *LOCAL.psoft8.090615031245
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRole, probe:10020
MESSAGE : Failed to update database configuration parameter HADR_DB_ROLE.
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFEBC3C : FFFF EBDF ....
2009-06-15-12.49.41.076111+480 I80112475A508 LEVEL: Error
PID : 1204454 TID : 1 PROC : db2agent (FS90PRD) 0
INSTANCE: psoft8 NODE : 000 DB : FS90PRD
APPHDL : 0-1186 APPID: *LOCAL.psoft8.090615031245
FUNCTION: DB2 UDB, database utilities, sqludsfp, probe:556
MESSAGE : Failed to set database configuration parameter HADR_DB_ROLE to standard
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFEB920 : FFFF EBDF ....
2009-06-15-12.49.41.076300+480 I80112984A450 LEVEL: Severe
PID : 1204454 TID : 1 PROC : db2agent (FS90PRD) 0
INSTANCE: psoft8 NODE : 000 DB : FS90PRD
APPHDL : 0-1186 APPID: *LOCAL.psoft8.090615031245
FUNCTION: DB2 UDB, database utilities, sqludsfp, probe:559
MESSAGE : DiagData
DATA #1 : Hexdump, 8 bytes
0x0780000020BE4E18 : FFFF F80A FFFF EBDF ........
2009-06-15-12.49.41.076456+480 I80113435A430 LEVEL: Error
PID : 1204454 TID : 1 PROC : db2agent (FS90PRD) 0
INSTANCE: psoft8 NODE : 000 DB : FS90PRD
APPHDL : 0-1186 APPID: *LOCAL.psoft8.090615031245
FUNCTION: DB2 UDB, database utilities, sqludsfp, probe:559
DATA #1 : Hexdump, 8 bytes
0x0780000020BE4E18 : FFFF F80A FFFF EBDF ........
2009-06-15-12.49.41.121553+480 I80113866A361 LEVEL: Severe
PID : 1204454 TID : 1 PROC : db2agent (FS90PRD) 0
INSTANCE: psoft8 NODE : 000 DB : FS90PRD
APPHDL : 0-1186 APPID: *LOCAL.psoft8.090615031245
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:110
MESSAGE : Restore Terminated.
数据库是没有做HA的, 备下来的库 db cfg HADR_DB_ROLE 是 standard的.
第一次做数据库恢复就碰到这样的错误 ......
网上查了一遍了,找周围的人问了问,都没有找到合适的解决方法.
[ 本帖最后由 kevin1947 于 2009-6-17 18:26 编辑 ] |
|