Re: 2 standbys using dependency=
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: howard.latham@xxxxxxxxx
- Date: Fri, 14 Jan 2011 21:12:29 +0530
hi
Quote
I want to have two standbys on the standby box but I don't want to ship two
copies of archived logs
UnQuote
I am not sure whether this is possible, is ther any document that states it
is possible.
casue according to me when you ship to standby and further when it gets
applied onto the standby database, relevant views get updated and the
purpose of received archive is over.
I am not sure and you can try one workaround, which is, letus copy the
non-applied(just received copy) archive to some else destination on the same
host for your other standby.
may you want to do this to reduce the network traffice and as well as one
more standby on the same host.
it looks like usually RAC has one standby you are preparing RAC standby for
single node database..
have I understood you proprely..!
thanks..
subodh
On 14 January 2011 18:40, Howard Latham <howard.latham@xxxxxxxxx> wrote:
> Oracle 11G RH LINUX
>
> I have logged an SR but so far nothing!( 20 hours)
>
> I have a primary and standby db Not using Dataguard Broker.
>
> I want to have two standbys on the standby box but I don't want to ship two
> copies of archived logs
>
> So I tried using log_archive_dest_3=dependency=log_achive_dest_2
>
> The Primary stops archiving and stalls when the 3rd and last online redo
> log is full.
>
> The Dread message All logs need archiving appear in the alert log.
>
> The Database seems to start writing all three archived logs and hangs while
> it does it.
> If I shutdown the Standbys the Database appears to free up.
>
> This is a Production DB so I cant play around very much with Parms and am
> thinking of manually maintaining the second Standby.
>
> Any suggestions Folks?
>
> LGR Processes =10
>
>
>
> --
> Howard A. Latham
>
> Sent from my Nokia N97
>
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
