冬瓜兄,无牙兄,各位兄弟求助啊,有一棘手的问题
小弟近日开始接触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 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
在 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
问题不在这儿吧,人家不但要异机,还要不同instance
需要先在NBU中将异机恢复的限制取消。然后再恢复是数据。
在windows平台上是这样激活异机恢复的:
创建这个文件,然后重启NBU的服务。
<Install_path>NetBackupdbaltnamesNo.Restrictions
回复 2# wolfheader
还能说详细点啊,就是异机恢复不会做啊
先做好异机的文件恢复,bplist可以看到db2的内容再进行恢复