Originally Posted by mike2008
I'm writing a script that logs into the oracle db, execute a command "recover standby database;", then the command prompts the user to enter a value such as "auto" before the command can be executed.
Below is my script, but it is not performing the actions I wanted. Thanks in advance
sqlplus / as sysdba <<CMD
recover standby database;
What actions do you want the script to do? Can you type the desired actions at a keyboard? Why not write a script that performs the same actions you would perform if you were at a keyboard?
The script you are writing hasn't the remotest chance of giving you what you want, regardless of what you want, which you don't specify.