1

I have SYS access to a data guard standby DB, but i need to find the primary one. I was searching in Oracle Docs but couldn't find anything that could help.

  • can you access the standby host? Are you using dataguard broker? – miracle173 Jul 11 '15 at 19:18
1

You can check some options like checking FAL_SERVER parameter, LOG_ARCHIVE_DEST_n parameters, Dataguard Broker, Recovery Catalog, Cloud Control, etc.. if they are used, but none of them are mandatory for a DataGuard configuration.

In fact, the standby nodes doesn't need to send any kind of information to the Primary db at all. Since the heartbeat is checked from the Primary, the best approach is to query v$session and track down sessions connected as the, non-existent, "PUBLIC" schema.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy