如何用NBU備份db2的歸檔日志

aping2005

想用NBU的出口程序備份DB2的歸檔？不知道怎么來實(shí)現(xiàn)，Veritas的文檔寫的不是很詳細(xì)。\r\n\r\n設(shè)置了如下：\r\ndb2 update db cfg for sample using userexit on 啟用用戶出口 \r\n\r\ndb2 update db cfg for sample using logretain on 啟用歸檔日志 \r\n\r\n在NBU里面做了個policy叫db2_standard，是不是就可以了，\r\n怎么知道它是不是能正常工作，好像這個policy 沒有辦法手工執(zhí)行測試？\r\nbp.conf文件如下：\r\n\r\n# $Header: db2.conf,v 1.5 2007/04/12 14:05:29 $\r\n#\r\n# ***************************************************************************\r\n# * $Copyright: Copyright 1993 - 2007 Symantec Corporation, All Rights Reserved $ *\r\n# ***************************************************************************\r\n#\r\n# The following settings are used by NetBackup to backup/restore a DB2 database.\r\n#\r\n# Reminders:\r\n# 1) The specified policy must have a type of \"DB2\".\r\n# 2) The specified schedule must be defined for this policy.\r\n# 3) The DB2 database host must be entered as a client for this policy.\r\n#\r\n\r\nDATABASE SAMPLE\r\nOBJECTTYPE DATABASE\r\nPOLICY DB2\r\nSCHEDULE Default-Application-Backup\r\nENDOPER\r\n\r\n#\r\n# The following settings are used by NetBackup to backup/restore DB2 log files.\r\n#\r\n Reminders:\r\n# 1) DB2 transcation logs can be backed up/restored using  either \r\n#  (a) DB2 User Exit Program\r\n#       The specified policy must have a type of \"Standard\" (for UNIX DB2 \r\n#       host) or \"MS-Windows-NT\" (for Windows DB2 host).\r\n#\r\n#  (b) LOGARCHMETH1 can be configured to use NetBackup.\r\n#      (When LOGARCHMETH1 = \"VENDOR:NetBackup for DB2 agent\")\r\n#       This option is possible only for versions 8.2 and above.\r\n#       The specified policy must have a type of DB2.\r\n#\r\n# 2) The specified schedule must be defined for this policy.\r\n# 3) The DB2 database host must be entered as a client for this policy.\r\n#\r\n\r\n# ---------------------\r\n# DB2 User Exit Program\r\n# ---------------------\r\n# If DB2 log file archiving is enabled (DB2 USEREXIT ON), DB2 will invoke\r\n# the NetBackup user-exit program to backup & restore DB2 archive log files.\r\n# Using ARCFUNC SAVE causes log files to be archived to NetBackup storage,\r\n# as specified by the policy storage-unit setting.\r\n# Using ARCFUNC COPY causes log files to be archived to a disk directory.\r\n# Use ARCDIR to specify the destination directory for log file backup.\r\n# Use RETDIR to specify the source directory for log file restore.\r\n#\r\nDATABASE SAMPLE\r\nOBJECTTYPE ARCHIVE\r\nPOLICY db2_standard\r\nSCHEDULE userexit\r\nARCFUNC SAVE\r\n#ARCFUNC COPY\r\n#ARCDIR /home/db2inst1/arcdir\r\n#RETDIR /home/db2inst1/arcdir\r\nENDOPER

wolfheader

還需要文檔多全啊，呵呵，看這個注釋就夠了

wolfheader

出了什么問題？怎么解決的

冬瓜頭

我記得 備份的時候用一個“include log”，就可以順便備份log，不用單獨(dú)備份，restor的時候可以先提取出log。

alexbow

手工編譯db2uexit可以自動歸檔到NBU的