This is a multi-part message in MIME format.
------=_NextPart_000_0002_01C3A9C5.1749F480
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Adam,
Your script is not even running. An error 6 from a script run by NBU
indicates a failure trying to start the script. The reason you can run the
commands from the client side GUI, or from within RMAN, is that these
methods don't invoke a script from disk. How are you running the backup
from the schedule? Using a template? If so, then I think you need to
specify the .tpl in the template name (which your outpu doesn't show). If
you are not using a template, then you need a full path. There are a few
other things to check, but it would be helpful if you could be more specific
about how you are running this, for example:
- Do you specify a template you defined on the client
as the file list for the backup policy?
- Did you dump the template to a file and then specify that file
in the file list for the backup policy?
If you give these details, I can be of more help.
Mark Hickey
Senior Technology Consultant
Glasshouse Technologies,Inc.
www.glasshouse.com
=================================================
Message: 4
Date: Wed, 12 Nov 2003 21:44:18 -0600
From: adam AT tsatech DOT com
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
------=_NextPart_000_0002_01C3A9C5.1749F480
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DWindows-1252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.6249.1">
<TITLE>RE: Veritas-bu digest, Vol 1 #2688 - Oracle backup returns status =
6</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<BR>
<P><FONT SIZE=3D2>Adam,</FONT>
<BR><FONT SIZE=3D2> Your script is not even running. =
An error 6 from a script run by NBU indicates a failure trying to start =
the script. The reason you can run the commands from the client =
side GUI, or from within RMAN, is that these methods don't invoke a =
script from disk. How are you running the backup from the =
schedule? Using a template? If so, then I think you need to =
specify the .tpl in the template name (which your outpu doesn't =
show). If you are not using a template, then you need a full =
path. There are a few other things to check, but it would be =
helpful if you could be more specific about how you are running this, =
for example:</FONT></P>
<P><FONT SIZE=3D2> - Do you specify a template you defined =
on the client </FONT>
<BR><FONT SIZE=3D2> as the file list for the =
backup policy?</FONT>
<BR><FONT SIZE=3D2> - Did you dump the template to a file =
and then specify that file </FONT>
<BR><FONT SIZE=3D2> in the file list for the =
backup policy?</FONT>
<BR><FONT SIZE=3D2>If you give these details, I can be of more =
help.</FONT>
</P>
<P><FONT SIZE=3D2>Mark Hickey</FONT>
<BR><FONT SIZE=3D2>Senior Technology Consultant</FONT>
<BR><FONT SIZE=3D2>Glasshouse Technologies,Inc.</FONT>
<BR><FONT SIZE=3D2>www.glasshouse.com</FONT>
</P>
<P><FONT =
SIZE=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D</FONT>
</P>
<P><FONT SIZE=3D2>Message: 4</FONT>
<BR><FONT SIZE=3D2>Date: Wed, 12 Nov 2003 21:44:18 -0600</FONT>
<BR><FONT SIZE=3D2>From: adam AT tsatech DOT com</FONT>
<BR><FONT SIZE=3D2>To: veritas-bu AT mailman.eng.auburn DOT edu</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] Oracle 9.2.0 And Netbackup =
Agent 4.5</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi all,</FONT>
</P>
<P><FONT SIZE=3D2>I am trying to integrate the Oracle Agent with =
Netbackup 4.5 DC. We are </FONT>
<BR><FONT SIZE=3D2>currently at maintenance pack 5 and have installed =
the pertinent patches namely </FONT>
<BR><FONT SIZE=3D2>NBU_ORA_45_5_M.</FONT>
</P>
<P><FONT SIZE=3D2>Our problem is that if we when the schedule runs the =
backup fails with an exit </FONT>
<BR><FONT SIZE=3D2>status code of 6. When doing a Manual backup we =
get the same error. However, </FONT>
<BR><FONT SIZE=3D2>when we connect to RMAN and execute the commands from =
the template, the backup </FONT>
<BR><FONT SIZE=3D2>runs fine, and the Netbackup Activity Monitor =
reflects it.</FONT>
</P>
<P><FONT SIZE=3D2>Does anyone know why it works when executing the =
backup manually through RMAN, </FONT>
<BR><FONT SIZE=3D2>but not when it is initiated within Netbackup?</FONT>
</P>
<P><FONT SIZE=3D2>Thanks alot, any help is greatly appreciated. =
Sorry for the long e-mail.</FONT>
</P>
<P><FONT SIZE=3D2>-Adam</FONT>
</P>
<P><FONT SIZE=3D2>Relevant Info:</FONT>
</P>
<P><FONT SIZE=3D2>/usr/openv/netbackup/logs/dbclient <--No logs, I =
know that if there are no logs </FONT>
<BR><FONT SIZE=3D2>here it signifies that no communication exists =
between Netbackup and RMAN, </FONT>
<BR><FONT SIZE=3D2>however, the fact that I can initiate the backup from =
RMAN tells me there is </FONT>
<BR><FONT SIZE=3D2>connectivity between RMAN and Netbackup.</FONT>
</P>
<P><FONT SIZE=3D2>/usr/openv/netbackup/logs/bphdb <---Only has a log =
that shows the exit status </FONT>
<BR><FONT SIZE=3D2>code.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>ORACLE TEMPLATE</FONT>
</P>
<P><FONT SIZE=3D2>#^oracle template configuration file <<MUST BE =
FIRST IN FILE, DO NOT REMOVE>></FONT>
<BR><FONT SIZE=3D2># =
-----------------------------------------------------------------</FONT>
<BR><FONT SIZE=3D2># VERITAS NetBackup for oracle: Backup Configuration =
Template</FONT>
<BR><FONT SIZE=3D2># $VRTScprght: Copyright 1993 - 2002 VERITAS Software =
Corporation, All Rights </FONT>
<BR><FONT SIZE=3D2>Reserved $</FONT>
<BR><FONT SIZE=3D2>#</FONT>
<BR><FONT SIZE=3D2># Template level: 1.8.1</FONT>
<BR><FONT SIZE=3D2># Generated on: 11/12/03 20:50:25</FONT>
<BR><FONT SIZE=3D2># =
-----------------------------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2>TEMPLATE_ID1=3D2006</FONT>
<BR><FONT SIZE=3D2>TEMPLATE_ID2=3D5020</FONT>
<BR><FONT SIZE=3D2>TEMPLATE_OWNER=3Droot</FONT>
<BR><FONT SIZE=3D2>RUN_AS_USER=3Droot</FONT>
</P>
<P><FONT SIZE=3D2># =
-----------------------------------------------------------------</FONT>
<BR><FONT SIZE=3D2># BACKUP_TYPE is derived from the schedule type when =
this script</FONT>
<BR><FONT SIZE=3D2># is used in a NetBackup scheduled backup. For =
example, when:</FONT>
<BR><FONT SIZE=3D2># schedule type =
is  =
; BACKUP_TYPE is</FONT>
<BR><FONT SIZE=3D2># =
---------------- &nb=
sp; --------------</FONT>
<BR><FONT SIZE=3D2># Automatic =
Full &nb=
sp; INCREMENTAL =
LEVEL=3D0</FONT>
<BR><FONT SIZE=3D2># Automatic Differential Incremental INCREMENTAL =
LEVEL=3D1</FONT>
<BR><FONT SIZE=3D2># Automatic Cumulative Incremental =
INCREMENTAL LEVEL=3D1 CUMULATIVE</FONT>
<BR><FONT SIZE=3D2>#</FONT>
<BR><FONT SIZE=3D2># For a user initiated backup, BACKUP_TYPE is defined =
as shown.</FONT>
<BR><FONT SIZE=3D2># =
-----------------------------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2>BACKUP_TYPE=3DINCREMENTAL LEVEL=3D0</FONT>
<BR><FONT SIZE=3D2>PRE_AUTO_MOUNT=3DY</FONT>
<BR><FONT SIZE=3D2>ORACLE_HOME=3D/opt/oracle/product/8.1.7</FONT>
<BR><FONT SIZE=3D2>ORACLE_SID=3Dopenview</FONT>
<BR><FONT =
SIZE=3D2>TARGET_INIT_FILE=3D/opt/oracle/product/8.1.7/dbs/initopenview.or=
a</FONT>
<BR><FONT SIZE=3D2>TARGETDB_LOGIN=3Dsys</FONT>
<BR><FONT =
SIZE=3D2>TARGETDB_PASSWD=3D8d3c8733436c6306ab5ed96934d8f4dfeb8b535b9035b0=
86e74e72ad6bca01e6</FONT>
<BR><FONT =
SIZE=3D2>fe5340ab5473029469cd4b156175320f3d298e1164a0fcb4a121f4006a3c3e47=
</FONT>
</P>
<P><FONT SIZE=3D2># =
-----------------------------------------------------------------</FONT>
<BR><FONT SIZE=3D2># RMAN command section</FONT>
<BR><FONT SIZE=3D2># =
-----------------------------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2>RUN {</FONT>
</P>
<P><FONT SIZE=3D2>ALLOCATE CHANNEL ch00 </FONT>
<BR><FONT SIZE=3D2> TYPE 'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2>BACKUP</FONT>
<BR><FONT SIZE=3D2> INCREMENTAL LEVEL=3D0</FONT>
<BR><FONT SIZE=3D2> FORMAT 'bk_u%u_s%s_p%p_t%t'</FONT>
<BR><FONT SIZE=3D2> TAG 'sys_dba_user'</FONT>
<BR><FONT SIZE=3D2> DATABASE</FONT>
<BR><FONT SIZE=3D2> INCLUDE CURRENT =
CONTROLFILE;</FONT>
</P>
<P><FONT SIZE=3D2>RELEASE CHANNEL ch00;</FONT>
</P>
<P><FONT SIZE=3D2># Backup Archived Logs</FONT>
<BR><FONT SIZE=3D2>ALLOCATE CHANNEL ch00 </FONT>
<BR><FONT SIZE=3D2> TYPE 'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2>BACKUP</FONT>
<BR><FONT SIZE=3D2> FORMAT 'arch-s%s-p%p-t%t'</FONT>
<BR><FONT SIZE=3D2> ARCHIVELOG</FONT>
<BR><FONT SIZE=3D2> ALL</FONT>
<BR><FONT SIZE=3D2> DELETE INPUT;</FONT>
</P>
<P><FONT SIZE=3D2>RELEASE CHANNEL ch00;</FONT>
</P>
<P><FONT SIZE=3D2># Control file backup</FONT>
</P>
<P><FONT SIZE=3D2>ALLOCATE CHANNEL ch00 </FONT>
<BR><FONT SIZE=3D2> TYPE 'SBT_TAPE';</FONT>
<BR><FONT SIZE=3D2>BACKUP</FONT>
<BR><FONT SIZE=3D2> FORMAT 'bk_u%u_s%s_p%p_t%t'</FONT>
<BR><FONT SIZE=3D2> CURRENT CONTROLFILE;</FONT>
<BR><FONT SIZE=3D2>RELEASE CHANNEL ch00;</FONT>
<BR><FONT SIZE=3D2>}</FONT>
</P>
<P><FONT SIZE=3D2>The policy looks like this: </FONT>
<BR><FONT =
SIZE=3D2>------------------------------------------------------------</FO=
NT>
</P>
<P><FONT SIZE=3D2>Policy Name: =
openview_test_policy</FONT>
</P>
<P><FONT SIZE=3D2> Policy =
Type: Oracle</FONT>
<BR><FONT SIZE=3D2> =
Active: =
yes</FONT>
<BR><FONT SIZE=3D2> Effective date: =
11/12/2003 13:45:18</FONT>
<BR><FONT SIZE=3D2> Block Incremental: no</FONT>
<BR><FONT SIZE=3D2> Mult. Data Streams: no</FONT>
<BR><FONT SIZE=3D2> Frozen =
Image: 0</FONT>
<BR><FONT SIZE=3D2> Backup =
Copy: 0</FONT>
<BR><FONT SIZE=3D2> Client Encrypt: =
no</FONT>
<BR><FONT SIZE=3D2> Policy Priority: =
0</FONT>
<BR><FONT SIZE=3D2> Max Jobs/Policy: =
Unlimited</FONT>
<BR><FONT SIZE=3D2> Disaster Recovery: 0</FONT>
<BR><FONT SIZE=3D2> =
Residence: =
node2_dds3_STU1</FONT>
<BR><FONT SIZE=3D2> Volume =
Pool: oracle_pool</FONT>
<BR><FONT SIZE=3D2> =
Keyword:  =
; OpenView_DB</FONT>
</P>
<P><FONT SIZE=3D2> HW/OS/Client: =
HP9000-800 HP-UX11.00 node2</FONT>
</P>
<P><FONT SIZE=3D2> Include: openview_oracle</FONT>
</P>
<P><FONT SIZE=3D2> =
Schedule: =
oracle_openview_full</FONT>
<BR><FONT SIZE=3D2> =
Type: =
Automatic Full Backup</FONT>
<BR><FONT SIZE=3D2> =
Frequency: every 7 days</FONT>
<BR><FONT SIZE=3D2> Maximum =
MPX: 2</FONT>
<BR><FONT SIZE=3D2> Retention Level: 3 (1 =
month)</FONT>
<BR><FONT SIZE=3D2> Number Copies: =
1</FONT>
<BR><FONT SIZE=3D2> Fail on Error: =
0</FONT>
<BR><FONT SIZE=3D2> =
Residence: (specific storage unit =
not required)</FONT>
<BR><FONT SIZE=3D2> Volume =
Pool: (same as policy volume pool)</FONT>
<BR><FONT SIZE=3D2> Daily Windows:</FONT>
<BR><FONT =
SIZE=3D2> =
Tuesday 14:00:00 --> =
Tuesday 19:00:00</FONT>
</P>
<P><FONT SIZE=3D2> =
Schedule: =
Default-Application-Backup</FONT>
<BR><FONT SIZE=3D2> =
Type: =
Application Backup</FONT>
<BR><FONT SIZE=3D2> Maximum =
MPX: 1</FONT>
<BR><FONT SIZE=3D2> Retention Level: 3 (1 =
month)</FONT>
<BR><FONT SIZE=3D2> Number Copies: =
1</FONT>
<BR><FONT SIZE=3D2> Fail on Error: =
0</FONT>
<BR><FONT SIZE=3D2> =
Residence: (specific storage unit =
not required)</FONT>
<BR><FONT SIZE=3D2> Volume =
Pool: (same as policy volume pool)</FONT>
<BR><FONT SIZE=3D2> Daily Windows:</FONT>
<BR><FONT =
SIZE=3D2> =
Sunday 00:00:00 --> =
Sunday 24:00:00</FONT>
<BR><FONT =
SIZE=3D2> =
Monday 00:00:00 --> =
Monday 24:00:00</FONT>
<BR><FONT =
SIZE=3D2> =
Tuesday 00:00:00 --> =
Tuesday 24:00:00</FONT>
<BR><FONT =
SIZE=3D2> =
Wednesday 00:00:00 --> Wednesday =
24:00:00</FONT>
<BR><FONT =
SIZE=3D2> =
Thursday 00:00:00 --> Thursday =
24:00:00</FONT>
<BR><FONT =
SIZE=3D2> =
Friday 00:00:00 --> =
Friday 24:00:00</FONT>
<BR><FONT =
SIZE=3D2> =
Saturday 00:00:00 --> Saturday =
24:00:00</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<BR>
</BODY>
</HTML>
------=_NextPart_000_0002_01C3A9C5.1749F480--
|