v$database

'Control File Type      : ' || a.CONTROLFILE_TYPE  || chr(10) ||
'Control File Sequence  : ' || a.CONTROLFILE_SEQUENCE#  || chr(10) ||
'CTLFL Chg#             : ' || a.CONTROLFILE_CHANGE# || chr(10) ||
'Switch Status          : ' || a.SWITCHOVER_STATUS || chr(10)  ||
'Open Mode              : ' || a.OPEN_MODE || chr(10) ||
'Force Logging          : ' || a.force_logging   || chr(10)  ||
'Instance Name          : ' || b.INSTANCE_NAME   || chr(10) ||
'Host Name              : ' || b.HOST_NAME       || chr(10)  ||
'VERSION                : ' || b.VERSION         || chr(10) ||
'Insatnce Start Up Time : ' || to_char(STARTUP_TIME, 'MON-DD HH24:MI') ||
chr(10) ||
'Instance Status        : ' || b.STATUS          || chr(10)  ||
'Database Status        : ' || b.DATABASE_STATUS || chr(10)  ||
'Logins                 : ' || LOGINS
Database_and_Instance_Details
from v$database a, v$instance b
/

A typical output from the above statement looks like this:

DATABASE_AND_INSTANCE_DETAILS
---------------------------------------------
Database Name          : DNYTST10
Log Mode               : ARCHIVELOG
Last SCN Archived      : 15537780
Last SCN CheckPointed  : 15552965