冬瓜兄,无牙兄,各位兄弟求助啊,有一棘手的问题

发布于 2022-09-08 21:06:31 字数 4805 浏览 9 评论 5

小弟近日开始接触NBU6.5+TL2000+win2003

在网上搜到一篇, http://www.chinaunix.net/jh/34/1496996.html  ,学习了一下,效果不错。备份和本地恢复都可以完成。

异机恢复出现问题(异机恢复实例名不同),请大虾们赐教。

ERROR:C:Documents and SettingsAdministrator>db2 restore db newtmis_ load C:Progra~1
VeritasNetBackupbinnbdb2.dll
SQL2062N  存取介质 "C:Progra~1VeritasNetBackupbinnbdb2.dll"
时发生错误。原因码为:"516"。

db2 details:2010-5-13 15:38:06 - requesting resource db2
2010-5-13 15:38:06 - requesting resource backupserver.NBU_CLIENT.MAXJOBS.train
2010-5-13 15:38:06 - requesting resource backupserver.NBU_POLICY.MAXJOBS.DB2_DB_Policy
2010-5-13 15:38:06 - granted resource backupserver.NBU_CLIENT.MAXJOBS.train
2010-5-13 15:38:06 - granted resource backupserver.NBU_POLICY.MAXJOBS.DB2_DB_Policy
2010-5-13 15:38:06 - granted resource db2
2010-5-13 15:38:06 - estimated 0 kbytes needed
2010-5-13 15:38:06 - started process bpbrm (4220)
2010-5-13 15:38:07 - connecting
2010-5-13 15:38:08 - connected; connect time: 00:00:01
2010-5-13 15:39:21 - end writing
the requested operation was successfully completed(0)

以上是nbu成功的备份信息。

db2.conf详细信息:
# $Header: db2.conf,v 1.5 2007/04/12 14:05:29 $
#
# ***************************************************************************
# * $Copyright: Copyright 1993 - 2007 Symantec Corporation, All Rights Reserved $ *
# ***************************************************************************
#
# The following settings are used by NetBackup to backup/restore a DB2 database.
#
# Reminders:
# 1) The specified policy must have a type of "DB2".
# 2) The specified schedule must be defined for this policy.
# 3) The DB2 database host must be entered as a client for this policy.
#

DATABASE tmis_db
OBJECTTYPE DATABASE
POLICY DB2_DB_Policy
SCHEDULE Default-Application-Backup
ENDOPER

DATABASE newtmis_       
OBJECTTYPE DATABASE
POLICY DB2_DB_Policy
SCHEDULE Default-Application-Backup
ENDOPER

OBJECTTYPE ALTERNATE
SRCINST DB2
SRCALIAS tmis_db
DESTINST DB2
DESTALIAS newtmis_
ENDOPER
#
# The following settings are used by NetBackup to backup/restore DB2 log files.
#
#Reminders:
# 1) DB2 transcation logs can be backed up/restored using  either
#  (a) DB2 User Exit Program
#       The specified policy must have a type of "Standard" (for UNIX DB2
#       host) or "MS-Windows-NT" (for Windows DB2 host).
#
#  (b) LOGARCHMETH1 can be configured to use NetBackup.
#      (When LOGARCHMETH1 = "VENDOR:NetBackup for DB2 agent")
#       This option is possible only for versions 8.2 and above.
#       The specified policy must have a type of DB2.
#
# 2) The specified schedule must be defined for this policy.
# 3) The DB2 database host must be entered as a client for this policy.
#

# ---------------------
# DB2 User Exit Program
# ---------------------
# If DB2 log file archiving is enabled (DB2 USEREXIT ON), DB2 will invoke
# the NetBackup user-exit program to backup & restore DB2 archive log files.
# Using ARCFUNC SAVE causes log files to be archived to NetBackup storage,
# as specified by the policy storage-unit setting.
# Using ARCFUNC COPY causes log files to be archived to a disk directory.
# Use ARCDIR to specify the destination directory for log file backup.
# Use RETDIR to specify the source directory for log file restore.
#
#DATABASE restore
#OBJECTTYPE ARCHIVE
#POLICY DB2_Log_Policy
#SCHEDULE User
#ARCFUNC SAVE
#ARCFUNC COPY
#ARCDIR /home/db2inst1/arcdir
#RETDIR /home/db2inst1/arcdir
#ENDOPER

# --------------------------------------------------------------
# LOGARCHMETH1 = "VENDOR.." parameter for versions 8.2 and above
# Policy is of type DB2.
# --------------------------------------------------------------
#
# Comment the above DB2 User Exit section when using LOGARCHMETH1 = "VENDOR.."
#
#DATABASE restore
#OBJECTTYPE ARCHIVE
#POLICY DB2_ARCH_Policy
#SCHEDULE Default-Application-Backup
#ENDOPER

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(5

温折酒 2022-09-09 15:37:10

在 NetBackup 主服务器上创建以下文件之一:
install_pathNetBackupdbaltnamesNo.Restrictions
或者
install_pathNetBackupdbaltnamesdest_client_name
其中, dest_client_name 是允许作为备用恢复的目标客户机的客户机名称。例
如, client1。

db2 restore db db_being_restored load lib_path into new_db_name redirect

二货你真萌 2022-09-09 15:30:06

需要先在NBU中将异机恢复的限制取消。然后再恢复是数据。

在windows平台上是这样激活异机恢复的:
创建 ...
无牙 发表于 2010-05-18 19:49

    问题不在这儿吧,人家不但要异机,还要不同instance

昇り龍 2022-09-09 13:59:03

需要先在NBU中将异机恢复的限制取消。然后再恢复是数据。

在windows平台上是这样激活异机恢复的:
创建这个文件,然后重启NBU的服务。
<Install_path>NetBackupdbaltnamesNo.Restrictions

乖乖兔^ω^ 2022-09-09 12:39:49

回复 2# wolfheader

    还能说详细点啊,就是异机恢复不会做啊

过度放纵 2022-09-09 05:11:50

先做好异机的文件恢复,bplist可以看到db2的内容再进行恢复

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文