发新话题
打印

求助 NBU6.5备份Oracle 10g问题!!!!!!

求助 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

TOP

先用命令行试一试,排除以下软件安装的毛病。然后再看看脚本是不是有问题

TOP

不建议使用向导做脚本

使用NBU提供的备份脚本,修改修改就能用,一般没什么问题,注意oracle是RAC还是普通双机。

TOP

TOP

脚本没有改对。在改改。
@REM ---------------------------------------------------------------------------
@REM Replace H:\oracle\ora81, below, with the Oracle home path.
@REM ---------------------------------------------------------------------------

@set ORACLE_HOME=E:\oracle\product\10.2.0\db_1  \\需要修改

@REM ---------------------------------------------------------------------------
@REM Replace ora81, below, with the Oracle SID.
@REM ---------------------------------------------------------------------------

@set ORACLE_SID=oracle  \\需要修改

@REM ---------------------------------------------------------------------------
@REM Replace sys/manager, below, with the target connect string.
@REM ---------------------------------------------------------------------------

@set TARGET_CONNECT_STR=/  \\需要修改

@REM ---------------------------------------------------------------------------
@REM Set the Oracle Recovery Manager.
@REM ---------------------------------------------------------------------------

@set RMAN=%ORACLE_HOME%\BIN\rman.exe  \\需要修改

试试看。。。
顶!!!
支持!!!
你是对的!!!

TOP

脚本运行后,会在同目录下产生一个out问题,把那个发上来看看

TOP

发新话题