V$DG_BROKER_ROLE_CHANGE

V$DG_BROKER_ROLE_CHANGE displays information about the last ten role changes across a Data Guard broker configuration.

Column Datatype Description
EVENT VARCHAR2(30)

Type of role change:

  • Failover

  • Fast-Start Failover

  • Immediate Failover

  • Switchover
STANDBY_TYPE VARCHAR2(30)

Type of standby database:

  • Logical

  • Physical
OLD_PRIMARY VARCHAR2(30) Database unique name of the old primary database, that is, the primary database before the role change occurred
NEW_PRIMARY VARCHAR2(30) Database unique name of the new primary database, that is, the primary database after the role change occurred
FS_FAILOVER_REASON VARCHAR2(255)

If the role change was a fast-start failover, then this column displays the reason for the fast-start failover. For example, the primary database became disconnected.

Otherwise, the value of this column is null.
BEGIN_TIME TIMESTAMP(9)

Begin time of the role change

  • If the role change was a failover, then this column displays the time at which the ALTER DATABASE FAILOVER statement was issued on the target standby.
  • If the role change was a switchover, then this column displays the time at which the ALTER DATABASE SWITCHOVER statement was issued on the old primary database.
END_TIME TIMESTAMP(9)

End time of the role change

For both failover and switchover role changes, this column displays the time at which the ALTER DATABASE OPEN operation was completed on the first instance of the new primary database.

CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai.