Re: recover database using backup controlfile;

On 19 Dec 2003 05:56:23 -0800, rlmaier_at_ingr.com (Reid L Maier) wrote:

>I'm trying to do some automation by placing a set of Oracle commands
>into a DOS batch file. The "recover database using backup
>controlfile;" statement generates a prompt asking for the name of a
>logfile. Provided I know the name of the logfile, is there a way to
>prevent the prompt? Perhaps I can set an internal variable with the
>known logfile name and have the statement execute without the prompt?
>
>Any help is appreciated.
>
>Reid

set autorecovery on
However if the file isn't there the procedure will still prompt you for the file.

--
Sybrand Bakker, Senior Oracle DBA