Re: Best practices for "RECOVER MANAGED STANDBY DATABASE"

Pete Sharman wrote:
>
> Not sure if this is considered sage advice or not, but this is handled much more
> neatly in 9i, where you have the option to do the equivalent of a nohup on the
> RECOVER command. The syntax is RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM
> SESSION.
That's good advice for 9i. In the event that the original poster is stuck with 8i and ends up with a Unix platform, a simple shell script like:

#!/bin/ksh

nohup sqlplus "/ as sysdba"<<! > stby.out 2>&1 & recover managed standby database;
!

...should do the trick (the above works fine on HP/UX 11, and probably elsewhere). Can't help with the Windows side, though you could probably rig up something similar.

Regards,
Sean Received on Wed Apr 24 2002 - 23:53:08 CDT