That will cancel before applying any archives Mike Mayen.Shah@xxxxxxxxxx wrote:
#!/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 HelpHow 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