备份日志报错信息
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for ADSM1
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for ADSM1
SQL1015N The database is in an inconsistent state. SQLSTATE=55025
diag.log错误信息
2020-05-31-13.10.06.789594+480 E1522756848A615 LEVEL: Error
PID : 8388730 TID : 43303 PROC : db2sysc 0
INSTANCE: istdev1 NODE : 000 DB : ADSM1
APPHDL : 0-4103 APPID: *LOCAL.istdev1.200531051006
AUTHID : ISTDEV1 HOSTNAME: haapdbd01
EDUID : 43303 EDUNAME: db2agent (ADSM1) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:2535
MESSAGE : SQL1015N The database is in an inconsistent state.
DATA #1 : String, 91 bytes
Crash Recovery is needed.
Issue RESTART DATABASE on this node before issuing this command.
2020-05-31-13.10.08.585007+480 E1522763119A617 LEVEL: Error
PID : 8388730 TID : 43303 PROC : db2sysc 0
INSTANCE: istdev1 NODE : 000 DB : ADPMS1
APPHDL : 0-4104 APPID: *LOCAL.istdev1.200531051008
AUTHID : ISTDEV1 HOSTNAME: haapdbd01
EDUID : 43303 EDUNAME: db2agent (ADPMS1) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:2535
MESSAGE : SQL1015N The database is in an inconsistent state.
DATA #1 : String, 91 bytes
Crash Recovery is needed.
Issue RESTART DATABASE on this node before issuing this command.
2020-05-31-13.10.11.116773+480 I1522774042A476 LEVEL: Error
PID : 8388730 TID : 31546 PROC : db2sysc 0
INSTANCE: istdev1 NODE : 000 DB : ADRPT1
HOSTNAME: haapdbd01
EDUID : 31546 EDUNAME: db2logmgr (ADRPT1) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogVendor, probe:1630
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
每周日跑脚本自动备份
有的数据库能备份完成,有的会报如上错误
备份失败的数据库单独执行备份语句也能完成备份,不会报错
不知道错误出现在哪里,麻烦各位大佬点拨一下
db2diag.log 已经说的很清楚了。
SQL1015N The database is in an inconsistent state.
Crash Recovery is needed.
Issue RESTART DATABASE on this node before issuing this command.
由于数据库 ADSM1 处于不一致的状态,导致您的备份操作失败。
需要您使用 “ RESTART DATABASE ADSM1 ”命令重启数据库进行崩溃恢复后,使得数据库处于一致状态后,再执行备份脚本。