Home » RDBMS Server » Server Administration » "recover standby database until cancel" in script
"recover standby database until cancel" in script [message #372765] Wed, 07 March 2001 11:18 Go to next message
Roland Cadrin
Messages: 2
Registered: March 2001
Junior Member
I'm trying to include the command "recover standby database until cancel" in an SQL script. The problem is, this command expects user input. Is there a way to get around this? We are running Oracle 8.0.5. Thanks.

Report message to a moderator

Re: "recover standby database until cancel" in script [message #372780 is a reply to message #372765] Thu, 08 March 2001 21:21 Go to previous messageGo to next message
priya
Messages: 108
Registered: February 2000
Senior Member
since "until cancel" option is used the command will expect the user to press "enter" key or type cancel. Try just "recover standby database;" since you are including it the script. Go thru the related ora doc and then try. HTH.

Priya

Report message to a moderator

Re: "recover standby database until cancel" in script [message #372787 is a reply to message #372765] Fri, 09 March 2001 10:23 Go to previous message
Roland Cadrin
Messages: 2
Registered: March 2001
Junior Member
Thanks for responding to my question. I gave your suggestion a try, and it stopped with the same prompt. I've tried using every variation of this command, but I can't find a way of avoiding or getting past this prompt without human intervention.

Report message to a moderator

Previous Topic: Building SQL string and need single quotes
Next Topic: date time and long number
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 28 03:32:37 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.