Re: Put Oracle 8i standby in managed recovery
Date: Fri, 14 Aug 2009 15:52:05 +0200
Message-ID: <h63fgg$38b$1_at_s1.news.oleane.net>
Thanks for your help.
I know for Oracle but we can't migrate under an another version for the moment.
And for NET8 how to manage network or standby failures in the time. For
example during the week end.
I'm afraid of the stop of the production database if Oracle can not archive
its redologs because the remote localisation is unreachable.
Do a manual recover per day is so terrible or impossible ?
thanks
fabrice
"sybrandb" <sybrandb_at_gmail.com> a écrit dans le message de news:
3bb2b94e-fb26-4b58-b435-adfa10d7d51d_at_f37g2000yqn.googlegroups.com...
> On 14 aug, 13:09, "Fabrice" <emouc..._at_spaminfonietest.fr> wrote:
>> (re) hello
>>
>> Sorry for this new question.
>> I don't use Net 8 to transfer archived redologs from my production
>> database
>> to the standby.
>> I don't want to block the base in case of network failure.
>>
>> So I copy by script,each hours, the archived redologs file from the
>> production to the local destination directory of my standby (parameter
>> STANDBY_ARCHIVE_DEST). And regurlaly I execute this script :
>>
>> set autorecovery on
>> recover standby database
>>
>> Is there a way to realize a managed "recover standby" without use net8 to
>> transfer the logs. So I would like that the recover is automatic when I
>> copy
>> a archived redo in the right place on the standby.
>> It seems that the command "RECOVER MANAGED STANDBY DATABASE" works only
>> with
>> a network transfer by net8.
>>
>> Thanks for your help.
>
> No there is no way to realize a 'managed recover standby' without
> using Net8, and your concerns about Net8 are likely unjustified.
> Apart from that, Oracle 8i has been desupported a long time ago, and
> the Standby database feature has become much more robust in 9i
> (already desupported) and 10gR2.
>
> -----------
> Sybrand Bakker
> Senior Oracle DBA
Received on Fri Aug 14 2009 - 08:52:05 CDT