Re: Unix Shell Script Help

  • From: Mike Haddon <m.haddon@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 13 Feb 2009 17:47:50 -0600

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 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: