5.164 DBA_LOGSTDBY_LOG
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 ID of the archive log. The THREAD number is |
|
|
|
Start SCN of the branch |
|
|
|
Resetlogs identifier (a numeric form of the timestamp of the branch) |
|
|
|
Sequence number of the archive log file |
|
|
|
System change number (SCN) of the current archive log |
|
|
|
SCN of the next archive log |
|
|
|
Date of the current archive log |
|
|
|
Date of the next archive log |
|
|
|
Name of the archive log |
|
|
|
Time when the archive log was registered |
|
|
|
Indicates whether the beginning of the dictionary build is in this archive log ( |
|
|
|
Indicates whether the end of the dictionary build is in this archive log ( |
|
|
|
Indicates primarily whether a given foreign archived log has been applied fully by SQL Apply:
|
|
|
|
Number of blocks in the log |
|
|
|
Size of each block in the log |
Note:
The SCN values in this view correlate to the SCN values shown in the DBA_LOGSTDBY_PROGRESS
view.
Note:
In a CDB, this view shows data only when queried in the root.