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:
-
Past - The log stream has already been processed
-
Immediate Past - This is the most recently processed log stream; its status is transitioning from Current to Past
-
Current - The log stream is currently being processed
-
Immediate Future - This is the next log stream to be processed; its status is transitioning from Future to Current
-
Future - The log stream will be processed
|
SOURCE |
VARCHAR2(5) |
|
Describes how the log stream was started:
-
RFS - The RFS process created the log stream
-
User - A user registered the initial log file for the log stream
-
Synch - A user issued the ALTER DATABASE START LOGICAL STANDBY APPLY NEW PRIMARY DDL statement
-
Redo - The log stream information was recorded in the redo log
|
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. |