Using the dependency parameter in log_Archive_dest . so that both the standby can pick from the same archive destination in standby server. On Tue, May 10, 2011 at 2:09 AM, Emre Baransel <ebaransel@xxxxxxxxx> wrote: > so what 's the redo log source of second standby? primary or the first > standby? Where did you set log_archive_dest_x to ship redo to second > standby? > > > Y. Emre Baransel > > > ------------------------------ > *From:* K R <kp0773@xxxxxxxxx> > *To:* Emre Baransel <ebaransel@xxxxxxxxx> > *Cc:* "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx> > *Sent:* Tuesday, May 10, 2011 12:49 AM > *Subject:* Re: controlfile from standby database > > yes. and then modified it to suit the standby site > > On Mon, May 9, 2011 at 2:17 AM, Emre Baransel <ebaransel@xxxxxxxxx> wrote: > > Hi Kart, > do you copy init.ora from the 1. standby? > > Y. Emre Baransel > > > ------------------------------ > *From:* K R <kp0773@xxxxxxxxx> > *To:* Oracle-L@xxxxxxxxxxxxx > *Sent:* Monday, May 9, 2011 1:31 AM > *Subject:* controlfile from standby database > > All, > > I have a requirement to build 2 standby database on the standby server in > 10gR2. and this whole process needs to be automated . > > So I was thinking to build first standby database using rman duplicate > for standby > and then for building the second standby > -use all the datafile from first standby to copied for 2nd standby > -use the controlfile copied from first standby to be copied for 2nd > standby > > I see i am able to get all the datafiles copied without any issue > but when i copy the standby file and bring up the 2nd standby it do not > show my file_name_convert act properly. > > appreciate any suggestions. > > thanks > Kart > > > > > >