Standby databases

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: "ORACLE-L (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Feb 2012 15:27:06 +0000

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


Other related posts: