DB2离线备份与恢复

浏览： ℃

字体：大中小

发布时间：2013-12-15 22:18:55

来源：

DB2离线备份最简单的命令可以是这样:db2 backup db sample to c:/db2bak 　但实际做定时备份时哪这么简单,我整理了UNIX/Linux及Windows下做定时离线备份的脚本.很好用的.UNIX/Linux:1. 新建目录并授权以便存放备份文件[root@O11g64 tmp]# id db2inst1uid=1051(db2inst1) gid=1010(db2iadm1) groups=1010(db2iadm1),1020(db2fadm1)mkdir /db2bakchown -R db2inst1:db2iadm1 /db2bak2. 新建BAT文件db2bkoffline.sh

#author:xiongchuanliang#停顿数据库db2 connect to xcldbdb2 quiesce database immediate force connectionsdb2 connect reset#断开所有应用db2 force application all#离线备份db2 backup db xcldb to "/db2bak" with 2 buffers buffer 1024 parallelism 1 without prompting#取消数据库停顿db2 connect to xcldbdb2 unquiesce databasedb2 connect resetexit

3. 授权 chmod a+x /tmp/db2bkoffline.sh4. 运行备份 su - db2inst1 -c "/tmp/db2bkoffline.sh" >> /db2bak/db2bkoffline.logWindows下:1. 新建BAT文件db2bkoffline.bat

;;author:xiongchuanliang;;停顿数据库db2 connect to xcldbdb2 quiesce database immediate force connectionsdb2 connect reset;;断开所有应用db2 force application all;;离线备份db2 backup db xcldb to "c://db2bak" with 2 buffers buffer 1024 parallelism 1 without prompting;;取消数据库停顿db2 connect to xcldbdb2 unquiesce databasedb2 connect resetexit;

2. 运行备份db2cmd /c /w /i db2bkoffline.bat >> c://db2bkoffline.log
参数说明:-- 2 buffers : 两个缓存-- buffer 1024 : 缓存大小为1024-- parallelism 1 : 并行度上面这些参数在备份时,如果不指定DB2会自动调整成相关值.
离线备份的恢复也很简单db2 list history backup all for xcldbdb2 resotre db xcldb from /db2bak taken at 时间戳
MAIL:xcl_168@aliyun.comBlog:http://blog.csdn.net/xcl168

>更多相关文章