check whether a database is primary or standby

SQL> select DATABASE_ROLE from v$database;

DATABASE_ROLE
-------------------------------
PRIMARY

SQL> select DATABASE_ROLE from v$database;

DATABASE_ROLE
-------------------------------
PHYSICAL STANDBY