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