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?

I've asked this question before but the only response I received was
to 'set autorecovery on'. That doesn't explain which variable needs
to be set with the name of the logfile name nor how to set it.

Any help is appreciated.

Reid

Reid L Maier wrote:
output/banner etc, and you can pass in arguments on the command line (or
via your script).

more info here: http://www.orafaq.com/faqplus.htm

Curious to know why someone would trust a script to recover their
database. Seems rather risky.