最近做了几次DB2数据库的在线备份与恢复,趁此做一总结
DB2的备份
db2 backup db sample online to "/db2data/db2back/sample_bak/" compress include logs
DB2的恢复
1.如果能找到相应的归档日志的话
db2 restore database sample from /db2data/db2back/sample_bak taken at 20140222175801 without prompting
2.如果找不到日志的位置,选择指定目录恢复日志文件的方法
db2 "restore database sample from /db2data/db2back logtarget /db2data/log without prompting"
然后执行
db2 "rollforward database SQSDATA to end of logs and complete overflow log path (/db2data/log)"
查看某个备份文件之后的归档历史文件情况
db2 list history archive log since 20140222233750 for SAMPLE
查看备份恢复的进度
db2 list utilities show detail
查询rollforward状态db2 rollforward db sample query status