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