Check db role(primary/standby) - oracle database script

SELECT DATABASE_ROLE,
       DB_UNIQUE_NAME INSTANCE,
                      OPEN_MODE,
                      PROTECTION_MODE,
                      PROTECTION_LEVEL,
                      SWITCHOVER_STATUS
FROM V$DATABASE;