Re: 2 standbys using dependency=

  • From: Harel Safra <harel.safra@xxxxxxxxx>
  • To: howard.latham@xxxxxxxxx
  • Date: Fri, 14 Jan 2011 17:07:08 +0200

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

Other related posts: