DBA_LOGSTDBY_LOG displays information about the logs registered for a logical standby database. This view is for logical standby databases only.
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.
Start SCN of the branch
Resetlogs identifier (a numerical 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 (YES) or not (NO)
Indicates whether the end of the dictionary build is in this archive log (YES) or not (NO)
Indicates primarily whether a given foreign archived log has been applied fully by SQL Apply:
YES - SQL Apply has fully applied the foreign archived log and no longer needs it
CURRENT - SQL Apply is currently applying changes contained in the foreign archived log
NO - SQL Apply has not started applying any changes contained in the foreign archived log
FETCHING - SQL Apply encountered a corruption while reading redo records from this foreign archived log, and is currently using the automatic gap resolution to refetch a new copy of the log from the primary database
CORRUPT - SQL Apply encountered a corruption while reading redo records from this foreign archived log, and refetching a new copy of the archived log did not resolve the problem. SQL Apply will not refetch a new copy of this archived log automatically, and will require user intervention to manually register a new copy of the foreign archived log.
Number of blocks in the log
Size of each block in the log
The SCN values in this view correlate to the SCN values shown in the DBA_LOGSTDBY_PROGRESS view.