--
--      Some basic information about the database from v$database.
--
--      See -> os.sql for column PLATFORM_NAME
--
select
-- dbid,
   name,
   to_char(created, 'dd.mm.yyyy') created,
-- resetlogs_change#,                         -- System change number (SCN) at open resetlogs
-- resetlogs_time,                            
   log_mode,                                  -- NOARCHIVELOG, ARCHIVELOG, MANUAL
   checkpoint_change#,                        -- Last SCN checkpointed
   archive_change#,                           -- Database force archiving SCN. Any redo log with a start SCN below this will be forced to archive out.
   controlfile_type,                          -- STANDBY: database is in standby mode
                                              -- CLONE 
                                              -- BACKUP | CREATED : database is being recovered using a backup or created control file
                                              -- CURRENT database available for general use
   to_char(controlfile_created, 'dd.mm.yyyy')   "Ctrl Cr.t", -- Creation date of the control file
   controlfile_sequence#                        "Ctrl Seq",
   controlfile_change#                          "Ctrl SCN",
   controlfile_time                             "Ctrl Tim",
   open_resetlogs,
   open_mode,
   database_role
-- switchover_status
-- version_time
from
   v$database;