DBA_LOGSTDBY_LOG
displays information about the logs registered for a logical standby database. This view is for logical standby databases only.
Column | Datatype | NULL | Description |
---|---|---|---|
THREAD# |
NUMBER |
NOT NULL |
Thread ID of the archive log. The THREAD number is 1 for a single instance. For Real Application Clusters, this column will contain different numbers. |
RESETLOGS_CHANGE# |
NUMBER |
NOT NULL |
The start SCN of the branch |
RESETLOGS_ID |
NUMBER |
NOT NULL |
Resetlogs identifier (a numerical form of the timestamp of the branch) |
SEQUENCE# |
NUMBER |
NOT NULL |
Sequence number of the archive log file |
FIRST_CHANGE# |
NUMBER |
NOT NULL |
System change number (SCN) of the current archive log |
NEXT_CHANGE# |
NUMBER |
NOT NULL |
SCN of the next archive log |
FIRST_TIME |
DATE |
Date of the current archive log | |
NEXT_TIME |
DATE |
Date of the next archive log | |
FILE_NAME |
VARCHAR2(513) |
Name of the archive log | |
TIMESTAMP |
DATE |
Time when the archive log was registered | |
DICT_BEGIN |
VARCHAR2(3) |
Indicates whether the beginning of the dictionary build is in this archive log (YES ) or not (NO ) |
|
DICT_END |
VARCHAR2(3) |
Indicates whether the end of the dictionary build is in this archive log (YES ) or not (NO ) |
|
APPLIED |
VARCHAR2(7) |
Indicates whether each archive log has been applied (YES ) or not (NO ) |
Note:
The SCN values in this view correlate to the SCN values shown in theDBA_LOGSTDBY_PROGRESS
view.