Re: Unix Shell Script Help

From: Mike Haddon <m.haddon_at_tx.rr.com>
Date: Fri, 13 Feb 2009 17:47:50 -0600
Message-ID: <499606A6.40103_at_tx.rr.com>

That will cancel before applying any archives

Mike

Mayen.Shah_at_lazard.com 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_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-l

Received on Fri Feb 13 2009 - 17:47:50 CST