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) |
|