I have Oracle EBusiness Suite R12 running on 188.8.131.52. Our organization used to have most of the business in North America, South America and Europe; but now we are also in Australia, China and Indonesia. Previously running large reporting batch jobs and RMAN backups at night time in USA was feasible but now that is beginning to show up as performance issue for some countries.
I was thinking would it make sense to have a Active Data Guard logical standby database on a separate server in the same US based data center where we have our main servers and use that logical standy database for reporting and RMAN backups. I am especially concerned about RMAN backups. Would I be able to make RMAN backups from the logical standy database and somehow use those to recover our primary database if some issue happens?
Active Data Guard only deals with physical standbys. If you are using a logical standby you can always open the database without using Active Data Guard option.
http://docs.oracle.com/cd/E11882_01/server.112/e25608/rman.htm#sthref846 says that:
Backups of logical standby databases are not usable at the primary database.