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