Re: Best practices for "RECOVER MANAGED STANDBY DATABASE"

Sean and Pete -

Thanks very much for the wise words. Being an ex-Oracle tech support guy, I committed the #1 mistake of not identifying my OS and Oracle versions when stating the problem/question. I am indeed running Oracle8i (specifically 8.1.7.2). I'll go back through my Oracle9i new features things to see how or if I missed the enhanced "recover managed standby database..." command.

Bye,
Tom

Sean M wrote:

> 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 Thu Apr 25 2002 - 10:31:50 CDT