Hi all,
I'm currently undertaking a large effort of work to move our existing users (2000+) from 11g to 12c.
As part of this move, I am looking to apply DR.
Unfortunately, I came in halfway through and the original architecture was not drawn up correctly meaning that I have to come up with a DR solution on the fly.
As it stands, we have two physical servers (Both Windows 2012R2). One is in our Production environment. The other is in our DR environment. They are separated geographically (so cannot horizontally scale).
Both servers contain running versions of OBIEE12c that utilise different db schemas. These schemas however do get synced with one another from master host schema to DR host schema (and then vice versa in a DR scenario). Note: Only some tables are being synced. XMLP_% etc
We then have a SAN that currently stores the bidata folder for the production server.
My hope was that I could also point the DR server to that same folder but that would be too easy wouldn't it. Locks on files not to mention references to server names/ips etc put pay to that.
So now i'm wondering if it's possible to sync the two by just exporting the BAR file from Prod each night and in a DR scenario, importing the BAR.
The only issue I can see with that is that when Production is fixed, do you sync the BAR back the other way and risk overwriting changes that may have happened between the time the BAR backup was originally taken on PROD and the time PROD went dow
What is the best way of syncing these servers at this point?
Thanks in advance,
Adam