RE: Backup/rman script in Linux

From: Pakhutkin, Maxim (Max) <maxim.pakhutkin_at_paetec.com>
Date: Wed, 25 May 2005 07:55:33 -0400
Message-ID: <4C4E171C33ADBF43BFFE42978E1708C946C0E1@mail1-corp.corp.paetec.com>

Check your PATH:

ctp_at_pug:~> whereis rman
rman: /usr/X11R6/bin/rman /usr/bin/X11/rman /usr/X11/bin/rman ctp_at_pug:~>

Max

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Wednesday, May 25, 2005 7:48 AM
To: oracle-l_at_freelists.org
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/

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 25 2005 - 07:59:39 CDT