By querying v$database one can tell if the host is primary or standby For primary testdb> select database_role from v$database; DATABASE_ROLE ---------------- PRIMARY For Standby - Note you may need to connect to as sys as sysdba if the instance is in mount state testd> select database_role from v$database; DATABASE_ROLE ---------------- PHYSICAL STANDBY OR On … Continue reading How to tell/find if the instance is Primary/Standby? →