Re: Best practices for "RECOVER MANAGED STANDBY DATABASE"

In article <3CC82166.D33E800_at_noaa.gov>, Thomas says...
>
>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

If you have the 9i New Features for Administrators course material it's in chapter 5 (towards the end).

>
>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
>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Apr 25 2002 - 13:14:18 CDT