Databases Reference
In-Depth Information
F
MEMBERS
: The number of members in the log group
F
ARCHIVED
: The archive status (
YES
or
NO
)
F
STATUS
: The log status; it can be
UNUSED
,
CURRENT
,
ACTIVE
,
CLEARING
,
CLEARING_CURRENT
, or
INACTIVE
F
FIRST_CHANGE#
: The lowest system change number stored in the log
F
FIRST_TIME
: The time of the first system change number in the log
See also
F
The
V$LOG_HISTORY
and
V$LOGFILE
sections in this appendix
V$LOG_HISTORY
This view shows the log history from the control file.
Fields
The most relevant view fields are:
F
RECID
: The control file record ID
F
STAMP
: The control file record stamp
F
THREAD#
: The thread number of the archived log
F
SEQUENCE#
: The sequence number of the archived log
F
FIRST_CHANGE#
: The lowest system change number in the log
F
FIRST_TIME
: The time of the first entry in the log
F
NEXT_CHANGE#
: The highest system change number in the log
F
RESETLOGS_CHANGE#
: The
resetlogs change number
of the database
when the log was written
F
RESETLOGS_TIME
: The
resetlogs time
of the database when the log was written
See also
F
The
V$LOG
and
V$LOGFILE
sections in this appendix