Option 1:

In Primary database controlfile_type will show “CURRENT” and in standby conrolfile_type will show “STANDBY”.

SQL> SELECT controlfile_type FROM V$database;

CONTROLFILE_TYPE

----------------------------------

CURRENT

 

SQL> SELECT controlfile_type FROM V$database;

CONTROLFILE_TYPE

----------------------------------

STANDBY

 

Option 2:

In Primary database role will show “PRIMARY” and in standby database role will show “PHYSICAL STANDBY”

SQL> select database_role from v$database;

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

SQL> select database_role from v$database;

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