THREAD# |
NUMBER |
NOT NULL |
Thread ID of the archive log. The THREAD number is 1 for a single instance. For Real Application Clusters, this column will contain different numbers. |
RESETLOGS_CHANGE# |
NUMBER |
NOT NULL |
Start SCN of the branch |
RESETLOGS_ID |
NUMBER |
NOT NULL |
Resetlogs identifier (a numerical form of the timestamp of the branch) |
SEQUENCE# |
NUMBER |
NOT NULL |
Sequence number of the archive log file |
FIRST_CHANGE# |
NUMBER |
NOT NULL |
System change number (SCN) of the current archive log |
NEXT_CHANGE# |
NUMBER |
|
SCN of the next archive log |
FIRST_TIME |
DATE |
|
Date of the current archive log |
NEXT_TIME |
DATE |
|
Date of the next archive log |
FILE_NAME |
VARCHAR2(513) |
|
Name of the archive log |
TIMESTAMP |
DATE |
|
Time when the archive log was registered |
DICT_BEGIN |
VARCHAR2(3) |
|
Indicates whether the beginning of the dictionary build is in this archive log (YES) or not (NO) |
DICT_END |
VARCHAR2(3) |
|
Indicates whether the end of the dictionary build is in this archive log (YES) or not (NO) |
APPLIED |
VARCHAR2(8) |
|
Indicates primarily whether a given foreign archived log has been applied fully by SQL Apply:
-
YES - SQL Apply has fully applied the foreign archived log and no longer needs it
-
CURRENT - SQL Apply is currently applying changes contained in the foreign archived log
-
NO - SQL Apply has not started applying any changes contained in the foreign archived log
-
FETCHING - SQL Apply encountered a corruption while reading redo records from this foreign archived log, and is currently using the automatic gap resolution to refetch a new copy of the log from the primary database
-
CORRUPT - SQL Apply encountered a corruption while reading redo records from this foreign archived log, and refetching a new copy of the archived log did not resolve the problem. SQL Apply will not refetch a new copy of this archived log automatically, and will require user intervention to manually register a new copy of the foreign archived log.
|
BLOCKS |
NUMBER |
|
Number of blocks in the log |
BLOCK_SIZE |
NUMBER |
|
Size of each block in the log |
