DBA_LOGSTDBY_HISTORY
displays the history of switchovers and failovers in a Data Guard configuration. It does this by showing the complete sequence of redo log streams processed or created on the local system, across all role transitions. (After a role transition, a new log stream is started and the log stream sequence number is incremented by the new primary database.) This view is for logical standby databases only.
Column | Datatype | NULL | Description |
---|---|---|---|
STREAM_SEQUENCE# |
NUMBER |
Lists the sequence numbers for all log streams created or applied on the local system.
Note: A value of 0 indicates an unknown sequence order; this is reserved for future log streams. |
|
STATUS |
VARCHAR2(16) |
Description of the log stream processing:
|
|
SOURCE |
VARCHAR2(5) |
Describes how the log stream was started:
|
|
DBID |
NUMBER |
Database identifier of the primary database that created the log stream | |
FIRST_CHANGE# |
NUMBER |
Lowest system change number (SCN) in the current log file | |
LAST_CHANGE# |
NUMBER |
Highest system change number (SCN) in the current log file | |
FIRST_TIME |
DATE |
Time of the first SCN entry (FIRST_CHANGE# ) in the current log file |
|
LAST_TIME |
DATE |
Time of the last SCN entry (LAST_CHANGE# ) in the current log file |
|
DGNAME |
VARCHAR2(255) |
Unique database name (DB_UNIQUE_NAME ) of the primary database that produced the log stream. See V$DATAGUARD_CONFIG to display all database DB_UNIQUE_NAME values defined in the Data Guard configuration. |