[prev in list] [next in list] [prev in thread] [next in thread]
List: veritas-bu
Subject: Re: [Veritas-bu] RMAN Backups
From: ckstehman () pepco ! com
Date: 2007-07-30 12:44:13
Message-ID: OFE0935576.6B2D4EE5-ON85257328.0045A2A0-85257328.0045F7A0 () pepco ! com
[Download RAW message or body]
This is a multipart message in MIME format.
This is a multipart message in MIME format.
--=_alternative 0045F79D85257328_=
Content-Type: text/plain; charset="US-ASCII"
Content-Disposition: inline
We have been running the scripts successfully for the past 5 years. Is
this Windows or UNIX.?
What error do you get in the script's log file named start_*..out? That
will help.
Be sure the script is executable.
Here are some things to check.
The .sh script runs as root on UNIX system.
We modified the sample scripts for our environment in the following ways.
ORACLE_HOME, ORACLE_SID
and ORACLE_USER. and the NB_ORA_SCRIPTS must be set for your environment
From the .sh script.
========================================
echo "`date` ----------------Beginning of Script------------"
echo "Script name: $0"
ORACLE_HOME=/u01/app/oracle/product/10.2
export ORACLE_HOME
ORACLE_SID=scdb
export ORACLE_SID
ORACLE_USER=oracle
NB_ORA_SCRIPTS=/u01/rman
==========================================
Check the output of the .rcv script to see that you are connecting to the
recovery catalog and the target database correctly.
I can help better if I see the log from the script.
=============================
Carl Stehman
IT Distributed Services Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
ckstehman@pepco.com
"Shultz, Perry" <Perry.Shultz@allstate.com>
Sent by: veritas-bu-bounces@mailman.eng.auburn.edu
07/27/2007 03:28 PM
To
<veritas-bu@mailman.eng.auburn.edu>
cc
Subject
[Veritas-bu] RMAN Backups
We have been running RMAN backups for several years. But, our DBAs have
always submitted them outside of NetBackup (manually defining the
environmental variables required, etc.). RMAN initiates the connection
with NBU and everything functions. I am doing some testing where I would
like to use their scripts, but initiate them from the NetBackup scheduler
as an Automatic backup. When I execute their shell script, I get a Status
6 - indicating it could not backup the requested files and showing the
full qualified path to the script in the file list. There is no evidence
that the script was even submitted.
Any ideas? We are using NBU 6.0 in a very large installation but have
always used manually, external submission of backups. So some of the
nuances of scheduling internally are new to us - especially related to the
Oracle RMAN agent.
Thanks,
Perry Shultz _______________________________________________
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
=============================
Carl Stehman
IT Distributed Services Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
ckstehman@pepco.com
"Shultz, Perry" <Perry.Shultz@allstate.com>
Sent by: veritas-bu-bounces@mailman.eng.auburn.edu
07/27/2007 03:28 PM
To
<veritas-bu@mailman.eng.auburn.edu>
cc
Subject
[Veritas-bu] RMAN Backups
We have been running RMAN backups for several years. But, our DBAs have
always submitted them outside of NetBackup (manually defining the
environmental variables required, etc.). RMAN initiates the connection
with NBU and everything functions. I am doing some testing where I would
like to use their scripts, but initiate them from the NetBackup scheduler
as an Automatic backup. When I execute their shell script, I get a Status
6 - indicating it could not backup the requested files and showing the
full qualified path to the script in the file list. There is no evidence
that the script was even submitted.
Any ideas? We are using NBU 6.0 in a very large installation but have
always used manually, external submission of backups. So some of the
nuances of scheduling internally are new to us - especially related to the
Oracle RMAN agent.
Thanks,
Perry Shultz _______________________________________________
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
This Email message and any attachment may contain information that is
proprietary, legally privileged, confidential and/or subject to copyright
belonging to Pepco Holdings, Inc. or its affiliates ("PHI"). This Email is
intended solely for the use of the person(s) to which it is addressed. If
you are not an intended recipient, or the employee or agent responsible for
delivery of this Email to the intended recipient(s), you are hereby notified
that any dissemination, distribution or copying of this Email is strictly
prohibited. If you have received this message in error, please immediately
notify the sender and permanently delete this Email and any copies. PHI
policies expressly prohibit employees from making defamatory or offensive
statements and infringing any copyright or any other legal right by Email
communication. PHI will not accept any liability in respect of such
communications.
--=_alternative 0045F79D85257328_=
Content-Type: text/html; charset="US-ASCII"
Content-Disposition: inline
<br><font size=2 face="sans-serif">We have been running the scripts successfully
for the past 5 years. Is this Windows or UNIX.?</font>
<br>
<br><font size=2 face="sans-serif">What error do you get in the script's
log file named start_*..out? That will help. </font>
<br><font size=2 face="sans-serif">Be sure the script is executable.</font>
<br>
<br><font size=2 face="sans-serif">Here are some things to check.</font>
<br>
<br><font size=2 face="sans-serif">The .sh script runs as root on UNIX
system.</font>
<br><font size=2 face="sans-serif">We modified the sample scripts for our
environment in the following ways. ORACLE_HOME, ORACLE_SID</font>
<br><font size=2 face="sans-serif">and ORACLE_USER. and the NB_ORA_SCRIPTS
must be set for your environment</font>
<br><font size=2 face="sans-serif"> From the .sh script.</font>
<br><font size=2 face="sans-serif">========================================</font>
<br><font size=2 face="sans-serif">echo "`date` ----------------Beginning
of Script------------"</font>
<br><font size=2 face="sans-serif">echo "Script name: $0"</font>
<br>
<br><font size=2 face="sans-serif">ORACLE_HOME=/u01/app/oracle/product/10.2</font>
<br><font size=2 face="sans-serif">export ORACLE_HOME</font>
<br>
<br><font size=2 face="sans-serif">ORACLE_SID=scdb</font>
<br><font size=2 face="sans-serif">export ORACLE_SID</font>
<br>
<br><font size=2 face="sans-serif">ORACLE_USER=oracle</font>
<br>
<br>
<br><font size=2 face="sans-serif">NB_ORA_SCRIPTS=/u01/rman</font>
<br><font size=2 face="sans-serif">==========================================</font>
<br><font size=2 face="sans-serif">Check the output of the .rcv script
to see that you are connecting to the recovery catalog and the target database
correctly.</font>
<br>
<br><font size=2 face="sans-serif">I can help better if I see the log from
the script.</font>
<br>
<br>
<br><font size=2 face="sans-serif">=============================<br>
Carl Stehman<br>
IT Distributed Services Team<br>
Pepco Holdings, Inc.<br>
202-331-6619<br>
Pager 301-765-2703<br>
ckstehman@pepco.com</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Shultz, Perry"
<Perry.Shultz@allstate.com></b> </font>
<br><font size=1 face="sans-serif">Sent by: \
veritas-bu-bounces@mailman.eng.auburn.edu</font> <p><font size=1 \
face="sans-serif">07/27/2007 03:28 PM</font> <td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif"><veritas-bu@mailman.eng.auburn.edu></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">[Veritas-bu] RMAN Backups</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 face="Arial">We have been running RMAN backups for several
years. But, our DBAs have always submitted them outside of NetBackup
(manually defining the environmental variables required, etc.). RMAN
initiates the connection with NBU and everything functions. I am
doing some testing where I would like to use their scripts, but initiate
them from the NetBackup scheduler as an Automatic backup. When I
execute their shell script, I get a Status 6 - indicating it could not
backup the requested files and showing the full qualified path to the script
in the file list. There is no evidence that the script was even \
submitted.</font> <p><font size=2 face="Arial">Any ideas? We are using NBU 6.0 \
in a very large installation but have always used manually, external submission
of backups. So some of the nuances of scheduling internally are new
to us - especially related to the Oracle RMAN agent.</font>
<p><font size=2 face="Arial"><i>Thanks,</i></font><font size=3> </font>
<p><font size=5 face="Arial"><b><i>Perry Shultz</i></b></font><font size=3>
</font><tt><font size=2>_______________________________________________<br>
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<br>
</font></tt>
<p>
<br><font size=2 face="sans-serif">=============================<br>
Carl Stehman<br>
IT Distributed Services Team<br>
Pepco Holdings, Inc.<br>
202-331-6619<br>
Pager 301-765-2703<br>
ckstehman@pepco.com</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Shultz, Perry"
<Perry.Shultz@allstate.com></b> </font>
<br><font size=1 face="sans-serif">Sent by: \
veritas-bu-bounces@mailman.eng.auburn.edu</font> <p><font size=1 \
face="sans-serif">07/27/2007 03:28 PM</font> <td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif"><veritas-bu@mailman.eng.auburn.edu></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">[Veritas-bu] RMAN Backups</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 face="Arial">We have been running RMAN backups for several
years. But, our DBAs have always submitted them outside of NetBackup
(manually defining the environmental variables required, etc.). RMAN
initiates the connection with NBU and everything functions. I am
doing some testing where I would like to use their scripts, but initiate
them from the NetBackup scheduler as an Automatic backup. When I
execute their shell script, I get a Status 6 - indicating it could not
backup the requested files and showing the full qualified path to the script
in the file list. There is no evidence that the script was even \
submitted.</font> <p><font size=2 face="Arial">Any ideas? We are using NBU 6.0 \
in a very large installation but have always used manually, external submission
of backups. So some of the nuances of scheduling internally are new
to us - especially related to the Oracle RMAN agent.</font>
<p><font size=2 face="Arial"><i>Thanks,</i></font><font size=3> </font>
<p><font size=5 face="Arial"><b><i>Perry Shultz</i></b></font><font size=3>
</font><tt><font size=2>_______________________________________________<br>
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu<br>
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu<br>
</font></tt>
<p>
<br><br>This Email message and any attachment may contain information that is \
proprietary, legally privileged, confidential and/or subject to copyright belonging \
to Pepco Holdings, Inc. or its affiliates ("PHI"). This Email is intended solely for \
the use of the person(s) to which it is addressed. If you are not an intended \
recipient, or the employee or agent responsible for delivery of this Email to the \
intended recipient(s), you are hereby notified that any dissemination, distribution \
or copying of this Email is strictly prohibited. If you have received this message \
in error, please immediately notify the sender and permanently delete this Email and \
any copies. PHI policies expressly prohibit employees from making defamatory or \
offensive statements and infringing any copyright or any other legal right by Email \
communication. PHI will not accept any liability in respect of such communications.
--=_alternative 0045F79D85257328_=--
_______________________________________________
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic