一个数据库大概需要了解的信息
1. SQL> select name,created,log_mode,open_mode ,platform_name from v$database;
NAME CREATED LOG_MODE OPEN_MODE PLATFORM_NAME
---------- ------------ ------------ -------------------- --------------------
ORCL 04-DEC-15 NOARCHIVELOG READ WRITE Linux x86 64-bit
2. SQL> select instance_name,host_name,version,status from gv$instance;
INSTANCE_NAME HOST_NAME VERSION STATUS
---------------- ------------------------- ----------------- ------------
orcl localhost.localdomain 11.2.0.4.0 OPEN
3. SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
4. SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /home/oracle/app/product/11.2.0/db_1/dbs/arch
Oldest online log sequence 23
Current log sequence 25
SQL>
5. SQL> select * from v$controlfile;
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------------ --- ---------- --------------
/home/oracle/app/oradata/orcl/control01.ctl NO 16384 594
/home/oracle/app/fast_recovery_area/orcl/control02.ctl NO 16384 594
6. SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------ ------------ ------------
1 1 25 52428800 512 1 NO CURRENT 1278418 26-OCT-16 2.8147E+14
2 1 23 52428800 512 1 NO INACTIVE 1271720 26-OCT-16 1275749 26-OCT-16
3 1 24 52428800 512 1 NO INACTIVE 1275749 26-OCT-16 1278418 26-OCT-16
7. SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
3 ONLINE /home/oracle/app/oradata/orcl/redo03.log NO
2 ONLINE /home/oracle/app/oradata/orcl/redo02.log NO
1 ONLINE /home/oracle/app/oradata/orcl/redo01.log NO
8. SQL> select tablespace_name,status,logging,contents,extent_management,segment_space_management from dba_tablespaces;
TABLESPACE_NAME STATUS LOGGING CONTENTS EXTENT_MAN SEGMEN
------------------------------ --------- --------- --------- ---------- ------
SYSTEM ONLINE LOGGING PERMANENT LOCAL MANUAL
SYSAUX ONLINE LOGGING PERMANENT LOCAL AUTO
UNDOTBS1 ONLINE LOGGING UNDO LOCAL MANUAL
TEMP ONLINE NOLOGGING TEMPORARY LOCAL MANUAL
USERS ONLINE LOGGING PERMANENT LOCAL AUTO
9. SQL> select file_name,tablespace_name,bytes/1024/1024/1024 G ,status,autoextensible from dba_data_files;
FILE_NAME TABLESPACE_NAME G STATUS AUT
-------------------------------------------------- ------------------------------ ---------- --------- ---
/home/oracle/app/oradata/orcl/users01.dbf USERS .004882813 AVAILABLE YES
/home/oracle/app/oradata/orcl/undotbs01.dbf UNDOTBS1 .229492188 AVAILABLE YES
/home/oracle/app/oradata/orcl/sysaux01.dbf SYSAUX .5078125 AVAILABLE YES
/home/oracle/app/oradata/orcl/system01.dbf SYSTEM .732421875 AVAILABLE YES
10 . SQL> select username,account_status,default_tablespace,created,profile from dba_users order by 1;
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE CREATED PROFILE
------------------------------ -------------------------------- ------------------------------ ------------ ------------------------------
ANONYMOUS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
APEX_030200 EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
APEX_PUBLIC_USER EXPIRED & LOCKED USERS 24-AUG-13 DEFAULT
APPQOSSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
CTXSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
DBSNMP EXPIRED & LOCKED SYSAUX 24-AUG-13 MONITORING_PROFILE
DIP EXPIRED & LOCKED USERS 24-AUG-13 DEFAULT
EXFSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
FLOWS_FILES EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
MDDATA EXPIRED & LOCKED USERS 24-AUG-13 DEFAULT
MDSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE CREATED PROFILE
------------------------------ -------------------------------- ------------------------------ ------------ ------------------------------
MGMT_VIEW EXPIRED & LOCKED SYSTEM 24-AUG-13 DEFAULT
OLAPSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
ORACLE_OCM EXPIRED & LOCKED USERS 24-AUG-13 DEFAULT
ORDDATA EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
ORDPLUGINS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
ORDSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
OUTLN EXPIRED & LOCKED SYSTEM 24-AUG-13 DEFAULT
OWBSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
OWBSYS_AUDIT EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
SCOTT OPEN USERS 24-AUG-13 DEFAULT
SI_INFORMTN_SCHEMA EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE CREATED PROFILE
------------------------------ -------------------------------- ------------------------------ ------------ ------------------------------
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED USERS 24-AUG-13 DEFAULT
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED USERS 24-AUG-13 DEFAULT
SYS OPEN SYSTEM 24-AUG-13 DEFAULT
SYSMAN LOCKED SYSAUX 24-AUG-13 DEFAULT
SYSTEM OPEN SYSTEM 24-AUG-13 DEFAULT
WMSYS EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
XDB EXPIRED & LOCKED SYSAUX 24-AUG-13 DEFAULT
XS$NULL EXPIRED & LOCKED USERS 24-AUG-13 DEFAULT
30 rows selected.