#!/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