Creating ReadOnly service in Oracle ADG (Active DataGuard)
Every setup generally has a problem of developers connecting to active (or Primary) instance to run a few selects to know the status of their transactions or may be a sort of Health check. If you have an Active DataGuard setup, create a service that runs only at standby site, and route all your reads (SELECTs) to offload the traffic and buffer utilisation at Primary site. Let us see how to do that.. Login to Primary site: oracle-pr>srvctl add service -s REPORT_DR_ONLY -d RACC