UNIX for Dummies Questions & Answers

Yes, i exported the path variable. It says RMAN command not found.

So is rman on that path then?

If it is, run the script with the -x flag passed to the shell and post the output - use CODE tags for this please

It said RMAN not found

This will be my last go at this:
The code you've shown does not contain an export statement after you set the PATH, have you since added this to your script?

Is rman on this path?

Please post the results of running with a -x flag on the end of the shell call (eg #!/bin/sh -x).

Please also post the full path to your rman binary so we can compare with what gets set during the PATH assignment (which will be visable thanks to the -x flag)

My code exit after shutdown the database.
echo `date +%c` >> $LOG_FILE
echo "Database BACKUP starting." >> $LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"; export PATH
rman target=/ << EOF
shutdown immediate
exit EOF
if [ $? -eq 0 ]
then
echo "Database shut down." >> $LOG_FILE
echo "Previous Backup is being removed." >> $LOG_FILE
touch /u03/backups/abu/junk/ rm /u03/backups/abu/*

echo "Cold backup being performed." >> $LOG_FILE
cp -p -f -v /u01/oracle/admin/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u02/oradata/SEED/* /u03/backups/abu/nightly_backup/
cp -p -f -v /u03/oradata/SEED/* /u03/backups/abu/nightly_backup/

echo "Cold backup of archive logs being performed." >> $LOG_FILE
mv -f -v /u01/app/oracle/product/10.2/dbs/arch/* /u03/backups/abu/nightly_backup/

echo "Restarting Database" >> $LOG_FILE
ORACLE_HOME=/u01/app/oracle/product/10.2; export ORACLE_HOME
ORACLE_SID=SEED; export ORACLE_SID
PATH="$PATH:$ORACLE_HOME/bin"; export PATH
rman target=/ << EOF
startup
exit
EOF

if [ $? -eq 0 ]
then
echo "Database started up." >> $LOG_FILE
else 'not startup>>&LOG_FILE
fi
echo `date +%c` >> $LOG_FILE
echo "Database BACKUP has completed." >> $LOG_FILE
My out put of the code shows below
RMAN>
using target database control instead of recovery
database closed
database dismounted
oracle instance shut down
RMAN> Recovery Manager complete
bash-3.00$

The script dont process rest of the command. I tried many way but not working.

Please help.

Your use of the "here" document is incorrect.

Code:

# BAD
rman target=/ << EOF
shutdown immediate
exit EOF

# GOOD
rman target=/ << EOF
shutdown immediate
exit
EOF

Whenvee you create a "here" doc using "<< EOF", the terminating "EOF" must be alone, on it's own line, no leading spaces, no comments, no nuthin'.