Re: Unix Shell Script Help
From: <Mayen.Shah_at_lazard.com>
Date: Fri, 13 Feb 2009 10:09:22 -0500
Message-ID: <OFFA58A4EB.75B92F7E-ON8525755C.00531FBF-8525755C.00534046_at_lazard.com>
#!/usr/bin/ksh
#
Date: Fri, 13 Feb 2009 10:09:22 -0500
Message-ID: <OFFA58A4EB.75B92F7E-ON8525755C.00531FBF-8525755C.00534046_at_lazard.com>
#!/usr/bin/ksh
#
$ORACLE_HOME/bin/sqlplus -s /nolog <<eof1
connect /as sysdba;
RECOVER database using backup controlfile until cancel;
cancel
exit 0;
eof1
HTH
Mayen
"Bala" <oratips_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org
Feb 12 2009 11:17 PM
Please respond to
oratips_at_gmail.com
To
"oracle-l" <oracle-l_at_freelists.org>
cc
Subject
Unix Shell Script Help
How do i supply "Cancel" in a Unix Shell script after the SQLPLUS command
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; any tips/ suggestions highly appreciated.
Thanks in Advance
( Hot backup, HP unix, Oracle 10.2.0.4)
-- Bala Rao -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 13 2009 - 09:09:22 CST