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