Ok, I didnt read this quite right. I think he has a logical standby in use, and he wants to make a physical standby of the logical. I have never done that, but I dont see how it would be a problem. On Thu, Feb 2, 2012 at 9:48 AM, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote: > I think the question was, can a logical standby also play the role of the > primary? My gut un-researched answer is most likely no. > > On Thu, Feb 2, 2012 at 10:41 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote: > >> I'm not sure it will work. The scn's will be different, and the dbid's >> will be different. Off the top of my head, I would say that the logical >> will have to be completely rebuilt to convert it to a physical standby.. >> On Thu, Feb 2, 2012 at 9:27 AM, Goulet, Richard >> <Richard.Goulet@xxxxxxxxxxx>wrote: >> >> > Has anyone done the following: >> > You have a primary database that is heavy into OLTP and >> has >> > a physical standby in another geographical location. >> > You create a logical standby locally for reporting/portal >> > purposes because the developers and business users want up to the minute >> > data and need their own schemas with their own views. >> > Since the two databases are different, there is a desire >> to >> > create a physical standby of the logical in the other geographical >> location >> > >> > I'm fine with the archivelog destinations that will be needed. The >> > question has anyone built a physical standby of a logical standby? >> > >> > Richard Goulet >> > Senior Oracle DBA/Na Team Leader >> > >> > >> > -- >> > //www.freelists.org/webpage/oracle-l >> > >> > >> > >> >> >> -- >> Andrew W. Kerber >> >> 'If at first you dont succeed, dont take up skydiving.' >> >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- //www.freelists.org/webpage/oracle-l