oracle v$database

 select dbid,name from v$database;
 select log_mode , OPEN_MODE , DATABASE_ROLE
   from v$database;
 --DataGuard
 select SWITCHOVER_STATUS  , PROTECTION_MODE , PROTECTION_LEVEL  
    from        v$database;