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 of the archived logs |
|
|
|
Name of the database which generated the redo logs |
|
|
|
Thread number of the archived redo log. The thread number is |
|
|
|
Sequence number of the archived redo log file |
|
|
|
System change number (SCN) of the current archived redo log |
|
|
|
System change number (SCN) of the next archived redo log |
|
|
|
Date and time of the current archived redo log |
|
|
|
Date and time of the next archived redo log |
|
|
|
Name of the archived redo log |
|
|
|
Time when the archived redo log was registered |
|
|
|
Indicates whether the beginning of the dictionary build is in the archived redo log ( |
|
|
|
Indicates whether the end of the dictionary build is in the archived redo log ( |
|
|
|
Indicates whether the redo log can be permanently removed ( |
|
|
|
Resetlogs change number of the database when the log was written |
|
|
|
Resetlogs time of the database when the log was written |