RE: Backup/rman script in Linux
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 May 2005 08:33:19 -0700 (PDT)
How do you know it doesn't pass in the variables? What happens?
Two suspicions I would have:
1. Are you sure you're calling Oracle RMAN and not PolyglotMan (a Linux
program for transforming man pages). Check the path in the script.
2. 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
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/
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Do You Yahoo!?
Yahoo! Small Business - Try our new Resources site!
--
//www.freelists.org/webpage/oracle-l
Other related posts:
