Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup/rman script in Linux

RE: Backup/rman script in Linux

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Wed, 25 May 2005 08:28:20 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B43974D@fiji.arraybp.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of J. Dex Sent: Wednesday, May 25, 2005 5: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

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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 25 2005 - 10:34:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US