Just a hunch. Are you running a template or a script. If you are running a
script, is it executable?
James Peppas
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of
adam AT tsatech DOT com
Sent: Thursday, November 13, 2003 5:44 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Oracle 9.2.0 And Netbackup Agent 4.5
Hi all,
I am trying to integrate the Oracle Agent with Netbackup 4.5 DC. We are
currently at maintenance pack 5 and have installed the pertinent patches
namely
NBU_ORA_45_5_M.
Our problem is that if we when the schedule runs the backup fails with an
exit
status code of 6. When doing a Manual backup we get the same error.
However,
when we connect to RMAN and execute the commands from the template, the
backup
runs fine, and the Netbackup Activity Monitor reflects it.
Does anyone know why it works when executing the backup manually through
RMAN,
but not when it is initiated within Netbackup?
Thanks alot, any help is greatly appreciated. Sorry for the long e-mail.
-Adam
Relevant Info:
/usr/openv/netbackup/logs/dbclient <--No logs, I know that if there are no
logs
here it signifies that no communication exists between Netbackup and RMAN,
however, the fact that I can initiate the backup from RMAN tells me there is
connectivity between RMAN and Netbackup.
/usr/openv/netbackup/logs/bphdb <---Only has a log that shows the exit
status
code.
ORACLE TEMPLATE
#^oracle template configuration file <<MUST BE FIRST IN FILE, DO NOT
REMOVE>> # -----------------------------------------------------------------
# VERITAS NetBackup for oracle: Backup Configuration Template
# $VRTScprght: Copyright 1993 - 2002 VERITAS Software Corporation, All
Rights
Reserved $
#
# Template level: 1.8.1
# Generated on: 11/12/03 20:50:25
# -----------------------------------------------------------------
TEMPLATE_ID1=2006
TEMPLATE_ID2=5020
TEMPLATE_OWNER=root
RUN_AS_USER=root
# -----------------------------------------------------------------
# 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 user initiated backup, BACKUP_TYPE is defined as shown. #
-----------------------------------------------------------------
BACKUP_TYPE=INCREMENTAL LEVEL=0
PRE_AUTO_MOUNT=Y
ORACLE_HOME=/opt/oracle/product/8.1.7
ORACLE_SID=openview
TARGET_INIT_FILE=/opt/oracle/product/8.1.7/dbs/initopenview.ora
TARGETDB_LOGIN=sys
TARGETDB_PASSWD=8d3c8733436c6306ab5ed96934d8f4dfeb8b535b9035b086e74e72ad6bca
01e6
fe5340ab5473029469cd4b156175320f3d298e1164a0fcb4a121f4006a3c3e47
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'bk_u%u_s%s_p%p_t%t'
TAG 'sys_dba_user'
DATABASE
INCLUDE CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
# Backup Archived Logs
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
BACKUP
FORMAT 'arch-s%s-p%p-t%t'
ARCHIVELOG
ALL
DELETE INPUT;
RELEASE CHANNEL ch00;
# Control file backup
ALLOCATE CHANNEL ch00
TYPE 'SBT_TAPE';
BACKUP
FORMAT 'bk_u%u_s%s_p%p_t%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
The policy looks like this:
------------------------------------------------------------
Policy Name: openview_test_policy
Policy Type: Oracle
Active: yes
Effective date: 11/12/2003 13:45:18
Block Incremental: no
Mult. Data Streams: no
Frozen Image: 0
Backup Copy: 0
Client Encrypt: no
Policy Priority: 0
Max Jobs/Policy: Unlimited
Disaster Recovery: 0
Residence: node2_dds3_STU1
Volume Pool: oracle_pool
Keyword: OpenView_DB
HW/OS/Client: HP9000-800 HP-UX11.00 node2
Include: openview_oracle
Schedule: oracle_openview_full
Type: Automatic Full Backup
Frequency: every 7 days
Maximum MPX: 2
Retention Level: 3 (1 month)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Daily Windows:
Tuesday 14:00:00 --> Tuesday 19:00:00
Schedule: Default-Application-Backup
Type: Application Backup
Maximum MPX: 1
Retention Level: 3 (1 month)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Daily Windows:
Sunday 00:00:00 --> Sunday 24:00:00
Monday 00:00:00 --> Monday 24:00:00
Tuesday 00:00:00 --> Tuesday 24:00:00
Wednesday 00:00:00 --> Wednesday 24:00:00
Thursday 00:00:00 --> Thursday 24:00:00
Friday 00:00:00 --> Friday 24:00:00
Saturday 00:00:00 --> Saturday 24:00:00
----------------------------------------------------------------------
This mail sent through Toaster-Horde (http://qmailtoaster.clikka.com/)
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|