首页 > 数据库技术 > 详细

db2 backup export

时间:2018-07-04 11:08:51      阅读:188      评论:0      收藏:0      [点我收藏+]

备份命令:

db2 backup db test to /db2data/

监控备份进度:

db2 list utilities show detail

Estimated Percentage Complete = 51 <-进度

检测备份文件的有效性:

db2ckbkp /db2data/TEST.0.db2inst1.NODE0000.CATN0000.20171017225437.001 

执行恢复操作

db2 restore db TEST from /home taken at 20171017225437 into test

SQL2523W  Warning!  Restoring to an existing database that is different from 
the database on the backup image, but have matching names. The target database 
will be overwritten by the backup version.  The Roll-forward recovery logs 
associated with the target database will be deleted.
Do you want to continue ? (y/n) y

监控恢复进度:

db2 list utilities show detail

此外可用db2pd命令:

 db2pd -utilities

 

db2 backup export

原文:https://www.cnblogs.com/dahaoran/p/9262247.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!