|
DBID |
NUMBER |
The database ID calculated when database is created and stored in all file headers |
|
NAME |
VARCHAR2(9) |
Name of the database |
|
CREATED |
DATE |
Creation date |
|
RESETLOGS_CHANGE# |
NUMBER |
Change# at open resetlogs |
|
RESETLOGS_TIME |
DATE |
Timestamp of open resetlogs |
|
PRIOR_RESETLOGS_CHANGE# |
NUMBER |
Change# at prior resetlogs |
|
PRIOR_RESETLOGS_TIME |
DATE |
Timestamp of prior resetlogs |
|
LOG_MODE |
VARCHAR2(12) |
Archive log mode (NOARCHIVELOG or ARCHIVELOG) |
|
CHECKPOINT_CHANGE# |
NUMBER |
Last SCN checkpointed |
|
ARCHIVE_CHANGE# |
NUMBER |
Last SCN archived |
|
CONTROLFILE_TYPE |
VARCHAR2(7) |
The type of control file:
STANDBY - indicates database is in standby mode
LOGICAL - indicates the database is a logical standby database (not a physical standby)
CLONE - indicates a clone database
BACKUP | CREATED - indicates database is being recovered using a backup or created control file
CURRENT - the control file changes to this type following a standby database activate or database open after recovery
|
|
CONTROLFILE_CREATED |
DATE |
Control file creation timestamp |
|
CONTROLFILE_SEQUENCE# |
NUMBER |
Control file sequence number incremented by control file transactions |
|
CONTROLFILE_CHANGE# |
NUMBER |
Last change# in backup control file. Set to NULL if the control file is not a backup. |
|
CONTROLFILE_TIME |
DATE |
Last timestamp in backup control file. Set to NULL if the control file is not a backup. |
|
OPEN_RESETLOGS |
VARCHAR2(11) |
(NOT ALLOWED | ALLOWED | REQUIRED) Indicates whether next database open allows or requires the resetlogs option |
|
VERSION_TIME |
DATE |
The version time |
|
OPEN_MODE |
VARCHAR2(10) |
Open mode information |
|
STANDBY_MODE |
VARCHAR2(11) |
PROTECTED or UNPROTECTED |
|
REMOTE_ARCHIVE |
VARCHAR2(11) |
|
|
ACTIVATION# |
NUMBER |
|
|
DATABASE_ROLE |
VARCHAR2(16) |
|
|
ARCHIVELOG_CHANGE# |
NUMBER |
|
|
SWITCHOVER_STATUS |
VARCHAR2(18) |
|
