DB2的数据库备份与恢复

最近做了几次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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23850820/viewspace-1097409/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23850820/viewspace-1097409/