求助 NBU6.5备份Oracle 10g问题!!!!!!
NBU6.5备份 Oracle10g:
操作系统:windows 2003 sp1
Oracle采用MSSC双机搭建
NBU6.5只安装了Master Server 备份介质为本地硬盘
在NBU客户端(即Oracle服务器端)通过备份向导生产模版,在客户端可以成功执行备份,但是在NBU服务器端制订了全备策略后,执行报错:
2004-2-26 9:45:19 - requesting resource BasicDiskSU
2004-2-26 9:45:19 - requesting resource backup221.NBU_CLIENT.MAXJOBS.oracluster
2004-2-26 9:45:19 - requesting resource backup221.NBU_POLICY.MAXJOBS.wydtest
2004-2-26 9:45:20 - granted resource backup221.NBU_CLIENT.MAXJOBS.oracluster
2004-2-26 9:45:20 - granted resource backup221.NBU_POLICY.MAXJOBS.wydtest
2004-2-26 9:45:20 - granted resource [email=MediaID=@aaaab;Path=D:\Storage]MediaID=@aaaab;Path=D:\Storage[/email]
2004-2-26 9:45:20 - granted resource BasicDiskSU
2004-2-26 9:45:20 - estimated 0 kbytes needed
2004-2-26 9:45:20 - started process bpbrm (2872)
2004-2-26 9:45:21 - connecting
2004-2-26 9:45:21 - connected; connect time: 00:00:00
2004-2-26 9:45:59 - end writing
failed trying to exec a command(29)
在网上搜索相关错误,发现有朋友遇到过类似的错误,但是没有明确的解决办法。
模版内容如下:
#^oracle template configuration file <<MUST BE FIRST IN FILE, DO NOT REMOVE>>
# -----------------------------------------------------------------
# Veritas NetBackup for oracle: Backup Configuration Template
# $VRTScprght: Copyright 1993 - 2007 Symantec Corporation, All Rights Reserved $
#
# Template level: 1.9.0
# Generated on: 02/26/04 09:43:50
# -----------------------------------------------------------------
TEMPLATE_ID1=30339
TEMPLATE_ID2=10034
TEMPLATE_OWNER=administrator
# -----------------------------------------------------------------
# BACKUP_TYPE is derived from the schedule type when this script
# is used in a NetBackup scheduled backup. For example, when:
# schedule type is BACKUP_TYPE is
# ---------------- --------------
# Automatic Full INCREMENTAL LEVEL=0
# Automatic Differential Incremental INCREMENTAL LEVEL=1
# Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE
#
# For a non-proxy user initiated backup, BACKUP_TYPE is defined as shown.
# -----------------------------------------------------------------
BACKUP_TYPE=INCREMENTAL LEVEL=0
ORACLE_HOME=c:\oracle\product\10.2.0\db_1
ORACLE_SID=OCTEST
TARGET_INIT_FILE=c:\oracle\product\10.2.0\db_1\database\initOCTEST.ora
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=oracluster,NB_ORA_POLICY=wydtest,NB_ORA_SERV=backup221';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'bk_u%u_s%s_p%p_t%t'
DATABASE;
RELEASE CHANNEL ch00;
# Backup Archived Logs
sql 'alter system archive log current';
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=oracluster,NB_ORA_POLICY=wydtest,NB_ORA_SERV=backup221';
BACKUP
FORMAT 'arch_u%u_s%s_p%p_t%t'
ARCHIVELOG
ALL
DELETE INPUT;
RELEASE CHANNEL ch00;
# Control file backup
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=oracluster,NB_ORA_POLICY=wydtest,NB_ORA_SERV=backup221';
BACKUP
FORMAT 'ctrl_u%u_s%s_p%p_t%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
在采用模版备份遇到困难后,准备采用NBU提供的默认备份脚本加以修改备份:
hot_database_backup.cmd
修改后如下:
@REM $Header: hot_database_backup_test.cmd,v 1.3 2005/11/28 19:01:53 $
@REM bcpyrght
@REM ***************************************************************************
@REM * $VRTScprght: Copyright 1993 - 2007 Symantec Corporation, All Rights