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