db2 前滚数据库_DB2前滚恢复

最新推荐文章于 2023-08-03 13:46:05 发布

胡匪

最新推荐文章于 2023-08-03 13:46:05 发布

阅读量297

点赞数

文章标签： db2 前滚数据库

本文链接：https://blog.csdn.net/weixin_36296444/article/details/114492935

版权

本文档展示了如何使用DB2的rollforward命令来恢复sample数据库到指定时间点。通过执行`rollforward db sample to 2021-02-21-01.14.00.000000 using local time overflow log path (/home/db2inst1/logs)`，成功地处理了从S0000266.LOG到S0000269.LOG的日志文件，最后的提交事务时间为2021-02-21-01.13.04.000000。

摘要由CSDN通过智能技术生成

[db2inst1@localhost LOGSTREAM0000]$ db2 "rollforward db sample to 2021-02-21-01.14.00.000000 using local time overflow log path (/home/db2inst1/logs) "

Rollforward Status

Input database alias = sample Number of members have returned status = 1

Member ID = 0 Rollforward status = DB working Next log file to be read = S0000270.LOG Log files processed = S0000266.LOG - S0000269.LOG Last committed transaction = 2021-02-21-01.13.04.000000 Local

DB20000I The ROLLFORWARD command completed successfully. [db2inst1@localhost LOGSTREAM0000]$ [db2inst1@localhost LOGSTREAM0000]$ [db2inst1@localhost LOGSTREAM0000]$ pwd /home/db2inst1/logs/NODE0000/LOGSTREAM0000 [db2inst1@localhost LOGSTREAM0000]$ ls LOGSTREAM0000 S0000266.LOG S0000267.LOG S0000268.LOG S0000269.LOG S0000270.LOG [db2inst1@localhost LOGSTREAM0000]$ db2 "rollforward db sample to 2021-02-21-01.14.00.000000 using local time and stop overflow log path (/home/db2inst1/logs) "

Rollforward Status

Input database alias = sample Number of members have returned status = 1

Member ID = 0 Rollforward status = not pending Next log file to be read = Log files processed = S0000266.LOG - S0000269.LOG Last committed transaction = 2021-02-21-01.13.04.000000 Local

DB20000I The ROLLFORWARD command completed successfully.