5.274 DBA_REGISTERED_ARCHIVED_LOG

DBA_REGISTERED_ARCHIVED_LOG displays information about all registered archived logfiles in the database.

Column Datatype NULL Description

CONSUMER_NAME

VARCHAR2(128)

NOT NULL

Consumer name of the archived logs

SOURCE_DATABASE

VARCHAR2(128)

Name of the database which generated the redo logs

THREAD#

NUMBER

NOT NULL

Thread number of the archived redo log. The thread number is 1 for a single instance. For Real Application Clusters, this column will contain different numbers.

SEQUENCE#

NUMBER

NOT NULL

Sequence number of the archived redo log file

FIRST_SCN

NUMBER

NOT NULL

System change number (SCN) of the current archived redo log

NEXT_SCN

NUMBER

System change number (SCN) of the next archived redo log

FIRST_TIME

DATE

Date and time of the current archived redo log

NEXT_TIME

DATE

Date and time of the next archived redo log

NAME

VARCHAR2(513)

Name of the archived redo log

MODIFIED_TIME

DATE

Time when the archived redo log was registered

DICTIONARY_BEGIN

VARCHAR2(3)

Indicates whether the beginning of the dictionary build is in the archived redo log (YES) or not (NO)

DICTIONARY_END

VARCHAR2(3)

Indicates whether the end of the dictionary build is in the archived redo log (YES) or not (NO)

PURGEABLE

VARCHAR2(3)

Indicates whether the redo log can be permanently removed (YES) or not (NO)

RESET_LOGS_CHANGE#

NUMBER

NOT NULL

Resetlogs change number of the database when the log was written

RESET_TIMESTAMP

NUMBER

NOT NULL

Resetlogs time of the database when the log was written