Very basic check of the status of an Oracle Data Guard Standby
select db_unique_name, open_mode, log_mode, database_role from v$database; DB_UNIQUE_NAME OPEN_MODE LOG_MODE DATABASE_ROLE ———————— ——————————– ———————————— ———————————————— THEPRDS READ ONLY WITH APPLY ARCHIVELOG PHYSICAL STANDBY