RE: Backup/rman script in Linux

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Wed, 25 May 2005 07:53:59 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E0450BBB8@ecogenemld50.Org.Collegeboard.local>

Try using ${*variable*} like this
#!/bin/sh
...
export ORACLE_SID=orcl9;
...
rman nocatalog msglog $log_dir/${date_time}_${ORACLE_SID}_RMAN_backup.log <<EOF >>

hth

Chris Marquez
Oracle DBA

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

From: oracle-l-bounce_at_freelists.org on behalf of J. Dex Sent: Wed 5/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 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
fi
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

--

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