RE: Backup/rman script in Linux

From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Wed, 25 May 2005 08:33:19 -0700 (PDT)
Message-ID: <20050525153319.98302.qmail@web20708.mail.yahoo.com>

How do you know it doesn't pass in the variables? What happens?

Two suspicions I would have:

Are you sure you're calling Oracle RMAN and not PolyglotMan (a Linux program for transforming man pages). Check the path in the script.
I've seen some differences between Public Domain KSH (pdksh) on Linux and the "official" KSH93. Which one are you running? You can find KSH93 on http://www.kornshell.com/ (Although I've not encountered any problems with shell variables so this may be a red herring...)
- Charlotte

---

This backup/rman script (korn shell) works fine in other environments but is

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

in Linux? Also, if I do it step for step via command prompt it works fine

as well. Just doesn't want to work in this script.

rman target system/$syspass@$ORACLE_SID catalog rman/$rmanpass@$RMAN_SID

log=$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=$1

ORACLE_SID=$1 export ORACLE_SID

. /u01/app/oracle/oraconfig/Oracle.env.vars

today=`date +%a`

export today

rmanpass=`cat ~/info/.passwd.rman`

export rmanpass

syspass=`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=$SIDBKUP/`date +%a`_rman_config.rpt <<EOF

report schema;

Express yourself instantly with MSN Messenger! Download today - it's FREE!

http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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

Do You Yahoo!?
Yahoo! Small Business - Try our new Resources site!

--

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