DB2备份分为离线备份和在线备份,在线备份恢复时必须要有归档日志,恢复后需要rollforward,才能连接DB,没有归档日志将不能rollforward,只能找IBM支持,将LFH文件发给他们,用修改后的LFH可以连接DB。遇到无法恢复的情况,可以将所有表中的数据导出成csv。
D:\TRAIN.0\DB2\NODE0000\CATN0000\20141120\115142.001
db2stop force
db2start
RESTORE DATABASE TRAIN FROM D:\\ TAKEN AT 20141120115142 TO C: INTO TRAIN WITH 2 BUFFERS BUFFER 1024 WITHOUT ROLLING FORWARD
RESTORE DATABASE TRAIN FROM D:\\ TAKEN AT 20141120115142 TO C: INTO TRAIN WITH 2 BUFFERS BUFFER 1024 WITHOUT ROLLING FORWARD
RESTORE DATABASE TRAIN FROM D:\\ TAKEN AT 20170314000000 INTO C: INTO TRAIN WITH 2 BUFFERS BUFFER 1024 WITHOUT ROLLING FORWARD