读书人

DB2存档恢复语句

发布时间: 2012-09-03 09:48:39 作者: rapoo

DB2归档恢复语句
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))";

读书人网 >其他数据库

热点推荐