Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

The statement:

RECOVER DATABASE UNTIL CANCEL

prompts once to select the archive log file. Is there a way to pre specify the value so as to be able to use it in a script without prompt?

I have tried:

RECOVER AUTOMATIC DATABASE UNTIL CANCEL

But it still does prompt.

share|improve this question

1 Answer

up vote 3 down vote accepted

Issue a SET AUTORECOVERY ON first.

share|improve this answer
I added a blank line in the script, which did the trick - as i only needed to press ENTER during prompt. I'll try your way also. – Jay Nov 7 '12 at 16:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.