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.
Oracle DataGuard: Find primary from standby DB
dataguardoraclestandby
Related Question
- Oracle Standby License – Understanding Licensing Requirements
- Linux – From RAC to Standby RAC With Active Dataguard
- Oracle Data Guard – Preventing Logical Standby Issues After Flashback
- Standard Time Delay for Data Reflection in Standby Database
- Oracle Data Guard – Rebuild Configuration When Standby is Broken
- Dataguard the datafiles are created in another diskgroup
- 11g dataguard broken after primary ran out of space
Best Answer
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.