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 |
NOT NULL |
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 this archived redo log (YES) or not (NO) |
DICTIONARY_END |
VARCHAR2(3) |
|
Indicates whether the end of the dictionary build is in this archived redo log (YES) or not (NO) |
PURGEABLE |
VARCHAR2(3) |
|
Indicates whether or not this redo log can be permanently removed |
RESET_LOGS_CHANGE# |
NUMBER |
NOT NULL |
Resetlogs change# of the database when the log was written |
RESET_TIMESTAMP |
NUMBER |
NOT NULL |
Resetlogs time of the database when the log was written |
