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#

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

Start SCN of the branch

RESETLOGS_ID

NUMBER

NOT NULL

Resetlogs identifier (a numeric 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

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(8)

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.

BLOCKS

NUMBER

Number of blocks in the log

BLOCK_SIZE

NUMBER

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.