Re: 2 standbys using dependency=

  • From: Howard Latham <howard.latham@xxxxxxxxx>
  • To: Harel Safra <harel.safra@xxxxxxxxx>
  • Date: Fri, 14 Jan 2011 15:17:03 +0000

So Dependency= though documents isn't recommended?

On 14 January 2011 15:07, Harel Safra <harel.safra@xxxxxxxxx> wrote:

> Have a look at cascaded standby database:
>
> http://download.oracle.com/docs/cd/E14072_01/server.112/e10700/cascade_appx.htm
>
> Harel Safra
>
>
> On Fri, Jan 14, 2011 at 3:10 PM, 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
>>
>>
>


-- 
Howard A. Latham

Sent from my Nokia N97

Other related posts: