RE: Backup/rman script in Linux
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 May 2005 08:28:20 -0600
J.,
When the rman line is executed, what does your Oracle environment look =
like? FYI - I always fully qualify the rman executable with =
$ORACLE_HOME because there exists /usr/bin/X11/rman on my RedHat 3.0 =
Linux systems.
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of J. Dex
Sent: Wednesday, May 25, 2005 5:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Backup/rman script in Linux
This backup/rman script (korn shell) works fine in other environments =
but is=20
not working in Linux. It gets to this rman line and doesn't pass in the =
variables for the passwords or SIDs. Any idea why this would be =
different=20
in Linux? Also, if I do it step for step via command prompt it works =
fine=20
as well. Just doesn't want to work in this script.
rman target system/$syspass@$ORACLE_SID catalog rman/$rmanpass@$RMAN_SID =
log=3D$SIDBKUP/`date +%a`_rman_config.rpt <<EOF
The beginning of the script is as follows:
if [ $# -ne 1 ]
then echo "Usage Error. Usage: $0 <sid name>"
exit 1
export ORACLE_SID=3D$1
fi
ORACLE_SID=3D$1
export ORACLE_SID
. /u01/app/oracle/oraconfig/Oracle.env.vars
today=3D`date +%a`
export today
rmanpass=3D`cat ~/info/.passwd.rman`
export rmanpass
syspass=3D`cat ~/info/.passwd.$ORACLE_SID`
export syspass
cd $SIDBKUP
tar cvf $SIDBKUP/`date +%a`_Hot_tns.tar $ADMINDIR/pfile/*
rman target system/$syspass@$ORACLE_SID catalog rman/$rmanpass@$RMAN_SID =
log=3D$SIDBKUP/`date +%a`_rman_config.rpt <<EOF
report schema;
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's =
FREE!=20
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
//www.freelists.org/webpage/oracle-l
Other related posts: