一、说明

面对一个全新数据库的环境,Oracle DBA，首先应该了解什么?

二、过程

2.1 主机信息

2.1.1 cpu信息

1、查看cpu的型号：[node1@/root]#cat /proc/cpuinfo |grep -E "model name"​2、查看CPU的核数[node1@/root]#cat /proc/cpuinfo |grep processor |wc -l​

2.1.2 内存

[node1@/root]#free -g total used free shared buffers cachedMem: 126 71 54 0 0 4-/+ buffers/cache: 67 58Swap: 63 0 63[node1@/root]#

2.1.3 磁盘

[node1@/root]#df -TH

2.1.4 操作系统版本

[node1@/home/oracle]$cat /etc/redhat-release CentOS release 6.9 (Final)

2.2 oracle信息

2.2.1 实例sid

SQL> SELECT INSTANCE_NAME,STATUS FROM v$instance;​INSTANCE_NAME STATUS---------------- ------------zhzx1 OPEN

2.2.2 oracle的版本

SQL> select * from v$version;

2.2.3 字符集

SQL> select userenv('language') from dual;​

2.2.4 查看是单机还是集群

set serveroutput ondeclareinst_tab dbms_utility.instance_table;inst_cnt NUMBER; beginif dbms_utility.is_cluster_database thendbms_utility.active_instances(inst_tab, inst_cnt);dbms_output.put_line('-' || inst_tab.FIRST);dbms_output.put_line(TO_CHAR(inst_cnt));elsedbms_output.put_line('Not A Clustered Database');end if;end;/​Not A Clustered Database​PL/SQL 过程已成功完成。​

2.2.5 是否配置了DataGuard

select protection_mode, protection_level, remote_archive, database_role, dataguard_broker,guard_status from v$database;

2.2.6 是否启用了归档

conn /as sysdbaSQL> archive log list;

2.2.7 是否起用了flashback database特性

SQL>select flashback_on from v$database;​ 如果是，再进一步查看FLASHBACK RECOVERY AREA的配置情况SQL> show parameter db_recovery_file_dest;SQL> show parameter db_recovery_file_dest_size;

2.2.8 是否起用了force logging和补充日志

select FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL from v$database;​FOR SUPPLEME SUP SUP SUP SUP--- -------- --- --- --- ---NO NO NO NO NO NO​

2.2.9 了解控制文件组成

 select * from v$controlfile;​

2.2.10 了解日志文件组成

select l.group#, lf.type, lf.member, l.bytes, l.status LOG_STATUS, lf.status LOGFILE_STATUS from v$log l, v$logfile lfwhere l.group# = lf.group# order by 1,3;​

2.2.11 了解参数文件的组成和位置

SQL> show parameter spfile;​NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /alidata/app/oracle/product/11 .2.0/dbhome_1/dbs/spfileorcl.o raSQL> 

2.2.12 用户和profile

A， SQL> select name, value from gv$parameter where name = 'resource_limit';​B， SQL> select profile, resource_name, limit from dba_profiles order by 1,2;​C，​ SQL> select username, profile from dba_users where account_status = 'OPEN' order by 1;​​

2.2.13 表空间和数据文件的规划

SQL> select ts.name tablespace_name,df.name datfile_name,df.status,df.enabled,df.bytes,df.blocks from v$DATAfile df,v$tablespace ts where df.ts#=ts.ts#;　SQL> select * from v$tablespace;SQL> select * from v$datafile;

通过以上方法，DBA在面对一个新的数据库环境时，对其配置概况能做到了然于胸。工作起来才能得心应手！