Re: Unix Shell Script Help

  • From: Mayen.Shah@xxxxxxxxxx
  • To: oratips@xxxxxxxxx
  • Date: Fri, 13 Feb 2009 10:09:22 -0500

#!/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@xxxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Feb 12 2009 11:17 PM
Please respond to
oratips@xxxxxxxxx


To
"oracle-l" <oracle-l@xxxxxxxxxxxxx>
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

Other related posts: