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