加载中…
个人资料
微博
  • 博客等级：
  • 博客积分：
  • 博客访问：
  • 关注人气：
  • 获赠金笔：0支
  • 赠出金笔：0支
  • 荣誉徽章：
正文 字体大小：大 中 小

[转载]NBU恢复DB2

(2015-04-17 13:55:56)
标签：

转载
原文地址：NBU恢复DB2作者：Williamantec

http://s15/mw690/6965d96dtda5acd4518de&690

操作系统： SUSE linux Enterprise Server 11 SP1 64位

软件：     DB2 9.7.5。使用的IBM提供的DB2-SUSE11虚拟机

实例：     db2inst1相应帐户db2inst1

数据库：   QQQ（有些截图是PPP）

首先要查看客户端的DB2备份有哪些。需要用实例的管理员用户登录，使用NBU的“bplist”命令。

./bplist -C db2975 -S NBU75 -t 18 -l -R /

-C db2975

-C加客户端名称

-S NBU75

-S加Master Server名称

-t 18

DB2数据库类型

-l

显示文件详细信息，这里包含备份时所用的帐户和组

db2inst1@db2975:~> cd /usr/openv/netbackup/bin/

db2inst1@db2975:/usr/openv/netbackup/bin> ./bplist -C db2975 -t 18 -l -R /

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:26 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:26 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:25 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:25 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.1

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:22 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:22 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:22 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:21 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.1

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:16 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:16 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:16 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:15 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.1

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:10 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:10 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:09 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:09 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.1

http://s9/mw690/6965d96dtda5acdf74938&690

在Master Server上添加No.Restrictions文件。（本身文件名就叫这个，非TXT文件哦！！！）

Linux：/usr/openv/netbackup/db/altnames/No.Restrictions

Windows：install_pathNetBackupdbaltnamesNo.Restrictions

http://s5/mw690/6965d96dtda5ace8e1fe4&690

在NBU的DB2配置文件中添加“CLIENT_NAME”属性，指定客户端名称。

db2inst1@db2975:/usr/openv/netbackup/bin> cd /home//db2inst1/

db2inst1@db2975:~> more db2.conf

 

DATABASE QQQ

OBJECTTYPE DATABASE

POLICY DB2_QQQ

SCHEDULE Default-Application-Backup

CLIENT_NAME db2975

ENDOPE

http://s12/mw690/6965d96dtda5acf45901b&690

NBU恢复DB2也是通过DB2本身的命令进行的，所以只有在DB2存在的情况下才能恢复DB2数据库

db2inst1@db2975:/usr/openv/netbackup/bin> db2stop force

   ###   强制终止DB2服务，还原DB2需要切断DB2的所有连接

03/29/2013 12:36:42     0   0   SQL1064N  DB2STOP processing was successful.

SQL1064N  DB2STOP processing was successful.

db2inst1@db2975:/usr/openv/netbackup/bin> db2start

   ###   启动DB2服务

03/29/2013 12:36:56     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

db2inst1@db2975:/usr/openv/netbackup/bin> db2 restore db QQQ load /usr/openv/netbackup/bin/nbdb2.so64

   ###   还原DB2到最新的备份

SQL2539W  Warning!  Restoring to an existing database that is the same as the

backup image database.  The database files will be deleted.

Do you want to continue ? (y/n) y

DB20000I  The RESTORE DATABASE command completed successfully.

db2inst1@db2975:/usr/openv/netbackup/bin> db2 rollforward db QQQ to end of logs and stop

   ###   回滚DB2的日志到最新

 

                                 Rollforward Status

 

 Input database alias                   = QQQ

 Number of nodes have returned status   = 1

 

 Node number                            = 0

 Rollforward status                     = not pending

 Next log file to be read               =

 Log files processed                    = S0000005.LOG - S0000005.LOG

 Last committed transaction             = 2013-03-29-04.25.54.000000 UTC

 

DB20000I  The ROLLFORWARD command completed successfully.

db2inst1@db2975:/usr/openv/netbackup/bin> exit

logout

db2975:~ # rcdb2 restart

Stopping DAS:                                                                                                                                                             done

Stopping instance db2inst1 (50001) (/opt/ibm/db2/V9.7):                                                                                                                   done

Starting DAS:                                                                                                                                                             done

Starting instance db2inst1 (50001) (/opt/ibm/db2/V9.7):                                                                                                                   done

Activating database QWE for db2inst1                                                                                                                                      done

Activating database QQQ for db2inst1                                                                                                                                      done

db2975:~ #

重启DB2服务，QQQ数据库启动正常。

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

恢复20130329121546时的备份

db2inst1@db2975:/usr/openv/netbackup/bin> ./bplist -C db2975 -t 18 -l -R /

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:26 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:26 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:25 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:25 /DB2/QQQ/node0000/20130329122537/QQQ.0.db2inst1.node0000.0.20130329122537.1

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:22 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:22 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:22 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:21 /DB2/QQQ/node0000/20130329122146/QQQ.0.db2inst1.node0000.0.20130329122146.1

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:16 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:16 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:16 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:15 /DB2/QQQ/node0000/20130329121546/QQQ.0.db2inst1.node0000.0.20130329121546.1

-rw-rw---- db2inst1  db2grp1         20480 Mar 29 12:10 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.4

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:10 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.3

-rw-rw---- db2inst1  db2grp1          4096 Mar 29 12:09 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.2

-rw-rw---- db2inst1  db2grp1     109056000 Mar 29 12:09 /DB2/QQQ/node0000/20130329120934/QQQ.0.db2inst1.node0000.0.20130329120934.1

http://s11/mw690/6965d96dtda5ad02a75ca&690

db2975:~ # su - db2inst1

db2inst1@db2975:~> db2stop force

03/29/2013 12:41:32     0   0   SQL1064N  DB2STOP processing was successful.

SQL1064N  DB2STOP processing was successful.

db2inst1@db2975:~> db2start

03/29/2013 12:41:40     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

db2 restore db QQQ load /usr/openv/netbackup/bin/nbdb2.so64 taken at 20130329121546

   ###   taken at后添加通过bplist查到的要恢复的数据库备份时间点

SQL2539W  Warning!  Restoring to an existing database that is the same as the

backup image database.  The database files will be deleted.

Do you want to continue ? (y/n) y

DB20000I  The RESTORE DATABASE command completed successfully.

db2inst1@db2975:~> db2 rollforward db QQQ to end of logs and stop

 

                                 Rollforward Status

 

 Input database alias                   = QQQ

 Number of nodes have returned status   = 1

 

 Node number                            = 0

 Rollforward status                     = not pending

 Next log file to be read               =

 Log files processed                    = S0000002.LOG - S0000005.LOG

 Last committed transaction             = 2013-03-29-04.25.54.000000 UTC

 

DB20000I  The ROLLFORWARD command completed successfully.

db2inst1@db2975:~> exit

logout

db2975:~ # rcdb2 restart

Stopping DAS:                                                                                                                 done

Stopping instance db2inst1 (50001) (/opt/ibm/db2/V9.7):                                                                       done

Starting DAS:                                                                                                                 done

Starting instance db2inst1 (50001) (/opt/ibm/db2/V9.7):                                                                       done

Activating database QWE for db2inst1                                                                                          done

Activating database QQQ for db2inst1                                                                                          done

db2975:~ #

自此DB2恢复完成，如果恢复归档有问题敬请参考下一篇文章“NBU重定向恢复DB2”。

NBU Linux Client的安装

http://blog.sina.com.cn/s/blog_6965d96d0101g7a7.html

NBU与Netbackup

http://blog.sina.com.cn/s/articlelist_1768282477_15_1.html

NetBackup备份DB2数据库的步骤（使用Vendor方式备份DB2归档日志）

http://blog.sina.com.cn/s/blog_6965d96d0100tu71.html

DB2开启归档为NBU备份做准备

http://blog.sina.com.cn/s/blog_6965d96d0101lrxr.html

安装NBU-Client后针对DB2进行配置

http://blog.sina.com.cn/s/blog_6965d96d0101luav.html

如果选择Vendor方式备份DB2（DB2 8.2以上版本）可以参考一下文档

NetBackup备份DB2数据库的步骤（使用Vendor方式备份DB2归档日志）

http://blog.sina.com.cn/s/blog_6965d96d0100tu71.html

NBU7.0的Java Console 策略类型显示出错

http://blog.sina.com.cn/s/blog_6965d96d0101aldl.html

NBU备份DB2

http://blog.sina.com.cn/s/blog_6965d96d0101m1cz.html

 

 

北京同力天合网络技术有限公司

TAPP（Technical Assistance Partner Program）

朱宗智

 

本期明星销售：刘华

电话：13681194570

E-mail：liuhua@it9173.com

如果电话敬请告知获得途径“新浪博客”

喜欢

0

  

新浪BLOG意见反馈留言板　欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

Copyright © 1996 - 2022 SINA Corporation, All Rights Reserved

新浪公司 版权所有