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