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