Oraclev $ database View Analysis

GUARD_STATUS: prevents database modification (may be all or none or standby) SUPPLEMENTAL_LOG_DATA_MIN: SUPPLEMENTAL_LOG_DATA_PK:

GUARD_STATUS: prevents database modification (may be all or none or standby) SUPPLEMENTAL_LOG_DATA_MIN: SUPPLEMENTAL_LOG_DATA_PK:

SQL> desc v $ database
Is the name empty? Type
-------------------------------------
DBID NUMBER
NAME VARCHAR2 (9)
CREATED DATE
RESETLOGS_CHANGE # NUMBER
RESETLOGS_TIME DATE
PRIOR_RESETLOGS_C NUMBER
HANGE #
PRIOR_RESETLOGS_T DATE
IME
LOG_MODE VARCHAR2 (12)
CHECKPOINT_CHANGE NUMBER
#
ARCHIVE_CHANGE # NUMBER
CONTROLFILE_TYPE VARCHAR2 (7)
CONTROLFILE_CREAT DATE
ED
CONTROLFILE_SEQUE NUMBER
NCE #
CONTROLFILE_CHANG NUMBER
E #
CONTROLFILE_TIME DATE
OPEN_RESETLOGS VARCHAR2 (11)
VERSION_TIME DATE
OPEN_MODE VARCHAR2 (20)
PROTECTION_MODE VARCHAR2 (20)
PROTECTION_LEVEL VARCHAR2 (20)
REMOTE_ARCHIVE VARCHAR2 (8)
ACTIVATION # NUMBER
SWITCHOVER # NUMBER
DATABASE_ROLE VARCHAR2 (16)
ARCHIVELOG_CHANGE NUMBER
#
ARCHIVELOG_COMPRE VARCHAR2 (8)
SSION
SWITCHOVER_STATUS VARCHAR2 (20)
DATAGUARD_BROKER VARCHAR2 (8)
GUARD_STATUS VARCHAR2 (7)
SUPPLEMENTAL_LOG _ VARCHAR2 (8)
DATA_MIN
SUPPLEMENTAL_LOG _ VARCHAR2 (3)
DATA_PK
SUPPLEMENTAL_LOG _ VARCHAR2 (3)
DATA_UI
FORCE_LOGGING VARCHAR2 (3)
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2 (101
)
RECOVERY_TARGET_ I NUMBER
NCARNATION #
LAST_OPEN_INCARNA NUMBER
TION #
CURRENT_SCN NUMBER
FLASHBACK_ON VARCHAR2 (18)
SUPPLEMENTAL_LOG _ VARCHAR2 (3)
DATA_FK
SUPPLEMENTAL_LOG _ VARCHAR2 (3)
DATA_ALL
DB_UNIQUE_NAME VARCHAR2 (30)
STANDBY_BECAME_PR NUMBER
IMARY_SCN
FS_FAILOVER_STATU VARCHAR2 (22)
S
FS_FAILOVER_CURRE VARCHAR2 (30)
NT_TARGET
FS_FAILOVER_THRES NUMBER
HOLD
FS_FAILOVER_OBSER VARCHAR2 (7)
VER_PRESENT
FS_FAILOVER_OBSER VARCHAR2 (512
VER_HOST)
CONTROLFILE_CONVE VARCHAR2 (3)
RTED
PRIMARY_DB_UNIQUE VARCHAR2 (30)
_ NAME
SUPPLEMENTAL_LOG _ VARCHAR2 (3)
DATA_PL
MIN_REQUIRED_CAPT NUMBER
URE_CHANGE #

SQL>

Field description
DBID: a db id in the digital form, which is recorded in each data file header. You can determine which database the data file belongs.
NAME: Database NAME (Common Database NAME)
DB_UNIQUE_NAME :?
RESETLOGS_CHNAGE #: scn of the last resetlogs
RESETLOGS_TIME: the time of the last resetlogs.
PRIOR_RESETLOGS_CHANGE #: earlier (earliest ?) Scn for restlogs
PRIOR_RESETLOGS_TIME: earlier (earliest ?) Scn for restlogs
LOG_MODE: whether it is an archive mode. There are three possibilities (noarhivelog | archivelog | manual)
CHECKPOINT_CHANGE #: the scn of the last checkpoint. This value is from the control file.
ARCHIVE_CHANGE #: indicates that all redologs before this scn (smaller than this scn) will be automatically forcibly archived.
CONTROLFILE_TYPE: standby indicates that the database is in standby mode; clone indicates that the database is a clone database; backup | created indicates that the database is being recovered from the backup control file; current indicates that the database is in normal mode.
CONTROLFILE_CREATED: controls the time when a file is created.
CONTROLFILE_SEQUENCE #: an incremental serial number of the control file. Its purpose is unknown.
CONTROLFILE_CHANGE #: scn recorded in the control file
CONTROLFILE_TIME: The last time when the control file was updated.
OPEN_RESETLOGS: Indicates whether to use resetlogs to open the database next time. It may be (not allowed | required)
VERSION_TIME: version time (meaning unknown, usage unknown)
OPEN_MODE: indicates how the database is opened (read only | read write | mount)
PROTECTION_MODE: protection mode of the database (it seems to be useful in the case of dataguard)
PROTECTION_LEVEL: Protection Level
REMOTE_ARCHIVE: whether to allow remote archiving, that is, the value of the remote_archive_enable initialization parameter.
ACTIVATION #:?
SWTICHOVER #:?
DATABASE_ROLE: indicates that the database is logical standby | physical standby | primary
ARCHIVELOG_CHNAGE #: the scn at the end of the last archive operation, that is, the last SCN recorded in the latest archive log (according to the maximum next_change # In v $ archived_log #), note the differences between archive_change #
ARCHIVELOG_COMPRESSION: Archive compression status
SWITCHOVER_STATUS: switch over status
DATAGUARD_BROKER: Indicates whether the Data Guard configuration is being managed by the broker (ENABLED) or not (DISABLED)
GUARD_STATUS: prevents database modification (may be all, none, or standby)
SUPPLEMENTAL_LOG_DATA_MIN:
SUPPLEMENTAL_LOG_DATA_PK: If YES, it indicates that when a table with a primary key is updated, all the columns that constitute the primary key will also be recorded in the redo log.
SUPPLEMENTAL_LOG_DATA_UI: If YES, it indicates that when the table with the unqiue key is updated, all columns that constitute the unique key will also be recorded in the redo log.
SUPPLEMENTAL_LOG_DATA_FK: Same as above (record foreign key)
SUPPLEMENTAL_LOG_DATA_ALL: Same as above (record all fix_width maximun size column)
FORCE_LOGGING: indicates whether the database is in force logging mode.
PLATFORM_ID: operating system platform ID
PLATFORM_NAME: operating system platform name
RECOVERY_TARGET_INCARNATION #: indicates the scenario ID from which the database is restored. (a new scenario ID is created each time you use resetlogs to open the database)
LAST_OPEN_INCARNATION: The Scene number that was last opened
CURRENT_SCN: Current SCN of the database
STANDBY_BECAME_PRIMARY_SCN: SCN at which a physical standby database became a primary database.
FLASHBACK_ON: whether the flashback function is enabled
FS_FAILOVER_STATUS:
FS_FAILOVER_CURRENT_TARGET:
FS_FAILOVER_THRESHOLD:
FS_FAILOVER_OBSERVER_PRESENT:
FS_FAILOVER_OBSERVER_HOST:
Items that can be queried
A. Whether the archive mode is used
B. Is flashback enabled?
C. The scn of the current system
D. DBID, NAME, and Unique Name of the current database
E. checkpoint Information
F. Information about archived logs
G. Information related to controlfile: creation date, scn recorded in controlfile,
H. When was the database created?
I. operating system platform information of the database

Name and db_unique_name
Archive_change # And archivelog_change #