DBID |
NUMBER |
The database ID |
NAME |
VARCHAR2 |
Name of the database |
CREATED |
DATE |
Creation date |
LOG_MODE |
VARCHAR2 |
Archive log mode: NOARCHIVELOG or ARCHIVELOG |
CHECKPOINT_ CHANGE# |
NUMBER |
Last SCN checkpointed |
ARCHIVE_CHANGE# |
NUMBER |
Last SCN archived |
DBID |
NUMBER |
Database ID calculated when database is created and stored in all file headers |
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 |
CONTROLFILE_TYPE |
VARCHAR2(7) |
The type of control file:
STANDBY indicates database is in standby mode.
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 |