DB2归档恢复语句

最新推荐文章于 2024-06-01 07:10:51 发布

原创最新推荐文章于 2024-06-01 07:10:51 发布 · 172 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#DB2

数据库专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一套详细的 DB2 数据库备份与恢复操作流程，包括使用 db2stop, db2start, db2backup 等命令进行离线与在线备份，并演示了如何通过 db2restore 命令进行数据库恢复。

db2 connect to export
db2 get db cfg |more

db2stop force

db2start

db2 backup db export to /home

db2 connect to export
db2 update db cfg for export using LOGARCHMETH1 DISK:/home/exportlog
db2 backup db export to /home

db2 connect to export

db2stop force
db2start

db2 backup db export online to /home include logs;

归档恢复
su - db2inst1
db2 restore db export from /home taken at 20100824154648 logtarget /home/log
db2 "rollforward db export to end of backup and complete overflow log path (/home/log)"

db2 "create table test10 (id varchar(2),name varchar(8))";