標(biāo)題: 如何用NBU備份db2的歸檔日志 [打印本頁(yè)] 作者: aping2005 時(shí)間: 2008-10-18 22:51 標(biāo)題: 如何用NBU備份db2的歸檔日志 想用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里面做了個(gè)policy叫db2_standard，是不是就可以了，\r\n怎么知道它是不是能正常工作，好像這個(gè)policy 沒有辦法手工執(zhí)行測(cè)試？\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 時(shí)間: 2008-10-19 21:55
還需要文檔多全啊，呵呵，看這個(gè)注釋就夠了作者: wolfheader 時(shí)間: 2008-10-20 10:46
出了什么問題？怎么解決的作者: 冬瓜頭 時(shí)間: 2008-10-20 13:19
我記得 備份的時(shí)候用一個(gè)“include log”，就可以順便備份log，不用單獨(dú)備份，restor的時(shí)候可以先提取出log。作者: alexbow 時(shí)間: 2008-11-03 18:18 標(biāo)題: 回復(fù) #6 冬瓜頭 的帖子 手工編譯db2uexit可以自動(dòng)歸檔到NBU的
