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 SQL> select database_role from v$database; DATABASE_ROLE |