select
  DBID,                                    -- DBID NUMBER
  NAME,                                    -- NAME VARCHAR2(9)
  CREATED,                                 -- CREATED DATE
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESETLOGS_TIME,                          -- RESETLOGS_TIME DATE
  PRIOR_RESETLOGS_CHANGE#,                 -- PRIOR_RESETLOGS_CHANGE# NUMBER
  PRIOR_RESETLOGS_TIME,                    -- PRIOR_RESETLOGS_TIME DATE
  LOG_MODE,                                -- LOG_MODE VARCHAR2(12)
  CHECKPOINT_CHANGE#,                      -- CHECKPOINT_CHANGE# NUMBER
  ARCHIVE_CHANGE#,                         -- ARCHIVE_CHANGE# NUMBER
  CONTROLFILE_TYPE,                        -- CONTROLFILE_TYPE VARCHAR2(7)
  CONTROLFILE_CREATED,                     -- CONTROLFILE_CREATED DATE
  CONTROLFILE_SEQUENCE#,                   -- CONTROLFILE_SEQUENCE# NUMBER
  CONTROLFILE_CHANGE#,                     -- CONTROLFILE_CHANGE# NUMBER
  CONTROLFILE_TIME,                        -- CONTROLFILE_TIME DATE
  OPEN_RESETLOGS,                          -- OPEN_RESETLOGS VARCHAR2(11)
  VERSION_TIME,                            -- VERSION_TIME DATE
  OPEN_MODE,                               -- OPEN_MODE VARCHAR2(20)
  PROTECTION_MODE,                         -- PROTECTION_MODE VARCHAR2(20)
  PROTECTION_LEVEL,                        -- PROTECTION_LEVEL VARCHAR2(20)
  REMOTE_ARCHIVE,                          -- REMOTE_ARCHIVE VARCHAR2(8)
  ACTIVATION#,                             -- ACTIVATION# NUMBER
  SWITCHOVER#,                             -- SWITCHOVER# NUMBER
  DATABASE_ROLE,                           -- DATABASE_ROLE VARCHAR2(16)
  ARCHIVELOG_CHANGE#,                      -- ARCHIVELOG_CHANGE# NUMBER
  ARCHIVELOG_COMPRESSION,                  -- ARCHIVELOG_COMPRESSION VARCHAR2(8)
  SWITCHOVER_STATUS,                       -- SWITCHOVER_STATUS VARCHAR2(20)
  DATAGUARD_BROKER,                        -- DATAGUARD_BROKER VARCHAR2(8)
  GUARD_STATUS,                            -- GUARD_STATUS VARCHAR2(7)
  SUPPLEMENTAL_LOG_DATA_MIN,               -- SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(8)
  SUPPLEMENTAL_LOG_DATA_PK,                -- SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3)
  SUPPLEMENTAL_LOG_DATA_UI,                -- SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3)
  FORCE_LOGGING,                           -- FORCE_LOGGING VARCHAR2(3)
  PLATFORM_ID,                             -- PLATFORM_ID NUMBER
  PLATFORM_NAME,                           -- PLATFORM_NAME VARCHAR2(101)
  RECOVERY_TARGET_INCARNATION#,            -- RECOVERY_TARGET_INCARNATION# NUMBER
  LAST_OPEN_INCARNATION#,                  -- LAST_OPEN_INCARNATION# NUMBER
  CURRENT_SCN,                             -- CURRENT_SCN NUMBER
  FLASHBACK_ON,                            -- FLASHBACK_ON VARCHAR2(18)
  SUPPLEMENTAL_LOG_DATA_FK,                -- SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(3)
  SUPPLEMENTAL_LOG_DATA_ALL,               -- SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(3)
  DB_UNIQUE_NAME,                          -- DB_UNIQUE_NAME VARCHAR2(30)
  STANDBY_BECAME_PRIMARY_SCN,              -- STANDBY_BECAME_PRIMARY_SCN NUMBER
  FS_FAILOVER_STATUS,                      -- FS_FAILOVER_STATUS VARCHAR2(22)
  FS_FAILOVER_CURRENT_TARGET,              -- FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)
  FS_FAILOVER_THRESHOLD,                   -- FS_FAILOVER_THRESHOLD NUMBER
  FS_FAILOVER_OBSERVER_PRESENT,            -- FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)
  FS_FAILOVER_OBSERVER_HOST,               -- FS_FAILOVER_OBSERVER_HOST VARCHAR2(512)
  CONTROLFILE_CONVERTED,                   -- CONTROLFILE_CONVERTED VARCHAR2(3)
  PRIMARY_DB_UNIQUE_NAME,                  -- PRIMARY_DB_UNIQUE_NAME VARCHAR2(30)
  SUPPLEMENTAL_LOG_DATA_PL,                -- SUPPLEMENTAL_LOG_DATA_PL VARCHAR2(3)
  MIN_REQUIRED_CAPTURE_CHANGE#             -- MIN_REQUIRED_CAPTURE_CHANGE# NUMBER
from
  GV$DATABASE
where
  inst_id = USERENV('Instance')