I am installing OBIEE 18.104.22.168 on customer’s Disaster Recovery (DR) site and they already finished setting up DB for this DR site with following DR db details.
Physical Standby database configured in DR with data guard replicating the data between PROD and DR using Redo Apply. Db is not allowed for read/write.
1. Should I create OBIEE schema (DEV_BIPLATFORM, DEV_MDS) on DR db? Or should re use the PROD schema replicated on DR db? Is irt possible to reuse PROD BI schema (MDS,PLATFORM) on DR?
As I mentioned earlier, DR db is in standby mode with no access to read/write.
2. In case of Disaster, both Oracle EBS and EBS DB fail over to corresponding DR environments. Is It common practice to set up ETL for DR environment?
I would appreciate if you can share your experiences/best practices in setting up OBIEE for a DR site with above mentioned DB setup
To make use of high availability in OBIEE you have to configure two connection pool one on the primary site ( which would be the PROD ) and the secondary site ( DR Site ) . Refer to http://www.oracle.com/technetwork/database/features/availability/311400-134359.pdf for setup details.
The main problem with using DR Site for reporting is most of the base tables in EBS R12 DB [ in most of schema's like APPS , GL etc ] require call MO_GLOBAL_INIT ('S') or similar procedure each time you run a report based on these tables or even views based on these tables. Hence the reports will fail.
But if you are staging all these base tables into new schema with EBS r12 DB without referencing the base tables , yes you can use this new schema in DR site for reporting purposes in OBIEE.
Correct me if I am wrong. Let me know if it works.