V$DATABASE
displays information about the database from the control file.
Column | Datatype | Description |
---|---|---|
DBID |
NUMBER |
Database identifier calculated when the database is created and stored in all file headers |
NAME |
VARCHAR2(9) |
Name of the database |
CREATED |
DATE |
Creation date of the database |
RESETLOGS_CHANGE# |
NUMBER |
System change number (SCN) at open resetlogs |
RESETLOGS_TIME |
DATE |
Timestamp of open resetlogs |
PRIOR_RESETLOGS_CHANGE# |
NUMBER |
SCN at prior resetlogs |
PRIOR_RESETLOGS_TIME |
DATE |
Timestamp of prior resetlogs |
LOG_MODE |
VARCHAR2(12) |
Archive log mode:
|
CHECKPOINT_CHANGE# |
NUMBER |
Last SCN checkpointed |
ARCHIVE_CHANGE# |
NUMBER |
Database force archiving SCN. Any redo log with a start SCN below this will be forced to archive out. |
CONTROLFILE_TYPE |
VARCHAR2(7) |
Type of control file:
|
CONTROLFILE_CREATED |
DATE |
Creation date of the control file |
CONTROLFILE_SEQUENCE# |
NUMBER |
Control file sequence number incremented by control file transactions |
CONTROLFILE_CHANGE# |
NUMBER |
Last SCN in backup control file; null if the control file is not a backup |
CONTROLFILE_TIME |
DATE |
Last timestamp in backup control file; null if the control file is not a backup |
OPEN_RESETLOGS |
VARCHAR2(11) |
(NOT ALLOWED | ALLOWED | REQUIRED ) Indicates whether the next database open allows or requires the resetlogs option |
VERSION_TIME |
DATE |
Version time |
OPEN_MODE |
VARCHAR2(10) |
Open mode information:
|
PROTECTION_MODE |
VARCHAR2(20) |
Protection mode currently in effect for the database:
|
PROTECTION_LEVEL |
VARCHAR2(20) |
Aggregated protection mode currently in effect for the database:
Note: This column is an aggregation of the |
REMOTE_ARCHIVE |
VARCHAR2(8) |
Value of the REMOTE_ARCHIVE_ENABLE initialization parameter |
ACTIVATION# |
NUMBER |
Number assigned to the database instantiation |
SWITCHOVER# |
NUMBER |
Number assigned to the database switchover |
DATABASE_ROLE |
VARCHAR2(16) |
Current role of the database:
|
ARCHIVELOG_CHANGE# |
NUMBER |
Highest NEXT_CHANGE# (from the V$ARCHIVED_LOG view) for an archive log |
ARCHIVELOG_COMPRESSION |
VARCHAR2(8) |
Status of the archive log compression |
SWITCHOVER_STATUS |
VARCHAR2(20) |
Indicates whether switchover is allowed:
|
DATAGUARD_BROKER |
VARCHAR2(8) |
Indicates whether the Data Guard configuration is being managed by the broker (ENABLED ) or not (DISABLED ) |
GUARD_STATUS |
VARCHAR2(7) |
Protects data from being changed:
|
SUPPLEMENTAL_LOG_DATA_MIN |
VARCHAR2(8) |
Ensures that LogMiner (and any products building on LogMiner technology) will have sufficient information to support chained rows and various storage arrangements such as cluster tables:
See Also: Oracle Database SQL Reference for additional information about the |
SUPPLEMENTAL_LOG_DATA_PK |
VARCHAR2(3) |
For all tables with a primary key, indicates whether all columns of the primary key are placed into the redo log whenever an update is performed (YES ) or not (NO )
See Also: Oracle Database SQL Reference for more information about the |
SUPPLEMENTAL_LOG_DATA_UI |
VARCHAR2(3) |
For all tables with a unique key, indicates whether all other columns belonging to the unique key are placed into the redo log if any of the unique key columns are modified (YES ) or not (NO )
See Also: Oracle Database SQL Reference for more information about the |
FORCE_LOGGING |
VARCHAR2(3) |
Indicates whether the database is under force logging mode (YES ) or not (NO ) |
PLATFORM_ID |
NUMBER |
Platform identification number of the database |
PLATFORM_NAME |
VARCHAR2(101) |
Platform name of the database |
RECOVERY_TARGET_INCARNATION# |
NUMBER |
Incarnation number where all datafiles are recovered by the RECOVER DATABASE command |
LAST_OPEN_INCARNATION# |
NUMBER |
Record number of the incarnation in V$DATABASE_INCARNATION that was last opened successfully |
CURRENT_SCN |
NUMBER |
Current SCN; null if the database is not currently open. For a standby database, the current standby redo application SCN. |
FLASHBACK_ON |
VARCHAR2(3) |
Possible values are as follows:
|
SUPPLEMENTAL_LOG_DATA_FK |
VARCHAR2(3) |
For all tables with a foreign key, indicates whether all other columns belonging to the foreign key are placed into the redo log if any foreign key columns are modified (YES ) or not (NO )
See Also: Oracle Database SQL Reference for more information about the |
SUPPLEMENTAL_LOG_DATA_ALL |
VARCHAR2(3) |
For all columns, indicates whether all the fixed-length maximum size columns of that row are placed into the redo log (YES ) or not (NO )
See Also: Oracle Database SQL Reference for more information about the |
DB_UNIQUE_NAME |
VARCHAR2(30) |
Unique database name |
STANDBY_BECAME_PRIMARY_SCN |
NUMBER |
SCN at which a physical standby database became a primary database. This SCN is useful for converting a failed primary database into a physical standby database after a forced failover. |
FS_FAILOVER_STATUS |
VARCHAR2(21) |
Fast-start failover status:
See Also: Oracle Data Guard Broker for detailed descriptions of these values. |
FS_FAILOVER_CURRENT_TARGET |
VARCHAR2(30) |
DB_UNIQUE_NAME of the standby that is the current FSFO target standby for the Data Guard configuration |
FS_FAILOVER_THRESHOLD |
NUMBER |
Time in seconds that the observer will attempt to reconnect with a disconnected primary before attempting FSFO with the target standby |
FS_FAILOVER_OBSERVER_PRESENT |
VARCHAR2(7) |
YES - Observer is currently connected to the local database
Note: This field is consistent throughout a Real Application Clusters (RAC) environment; that is, if the observer is connected to any instance in the RAC, all will show a value of |
FS_FAILOVER_OBSERVER_HOST |
VARCHAR2(512) |
Machine name that is currently hosting the observer process |