Find out Instance is Primary or Standby
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