Oracle Analytics Server RCU schema for Prod and DR

Question

Production Environment: 1 set of HA Oracle Analytics Server

DR Environment: 1 set of HA Oracle Analytics Server

Data Guard on sync the Production Database to DR Database. So RCU schema(example prefix=OAS) will be show in both Database.

As I know schema will store some data like scheduler, DV, catalog. So, that i must sync the Prod RCU schema to DR RCU schema. from this i have to use same set of schema prefix so that they able to sync using Data Guard. (Correct me if i understand wrong)

In DR database I need to drop OAS RCU first and recreate same name prefix so that i able to create domain. If not will had the error the schema had been used. Due to Data Guard restore point.

Also, i try to copy whole production domain to DR server. It able to start but component obis and obisch was failed to start.

It there any other way to setup? Or my plan way is incorrect?

Thanks.

Gianni Ceresa · Accepted Answer

Hi,

I believe https://support.oracle.com/epmos/faces/DocContentDisplay?id=2943719.1 can answer part of the questioning you are having.

Because you have your database in sync in your DR location via data guard, you are trying to take a shortcut by not having to handle OAS DR separately.

That MOS document isn't exactly your case, but quite close (because your data guard sync copy of the database can be seen as being the same database).

I believe the "clean" OAS way to handle that is by moving snapshots from your live environment over to the DR environment and your DR environment doesn't touch the RCU schemas synchronized by data guard. Both environments will be on different schemas (different prefixes).

Of course there can be way to make it work differently, but this will probably require some hacking here and there to trick the DR OAS in thinking it is the real OAS when you start it (and your DR OAS can't be started until your live OAS will be down, to avoid 2 OAS instances putting their hands into the same RCU).

Didn't look at the doc recently to see if they do cover something about OAS DR implementation, and I also didn't read https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/asdrg/introduction-oracle-fusion-middleware-disaster-recovery.html about the FMW Disaster Recovery to see if it can apply to OAS somehow.

My guess would be that with your "cloned" (data guard sync) DB, if you also do clone the OAS installs, it will just work with little changes (maybe just a rename of host or IP address here and there). But it's things that would highly depends on how your environment is installed and everything else.

As for OBIS and OBISCH not starting, what does the logs says? Is that because of pointing to a wrong hostname or IP? Because you can write a script doing the required changes if that's the issue...