当DBA面对新的环境.doc

首先了解当前的oracle数据库版本和平台和相关信息这个很重要。Select * from v$version;Select * from dba_registry_database;Select dbid,name,open_mode,database_role,platform_name from v$instance;Select dbms_utility.port_string from dual;Set serveroutput onDeclareVer varchar2(100);Compat varchar2(100);BeginDbms_utility.db_version(ver,compat);Dbms_output.put_line(Version:|ver|Compatible|compat);End;第二，了解数据库安装了那些组件Col comp_name for a60Set linesize 150Select comp_name,version from dba_registry;第三，搞清楚当前的环境是单机还是集群Set serveroutput onDeclareInst_tab dbms_utility.instance_table;Inst_cnt number;BeginIf dbms_utility.is_cluster_database ThenDbms_utility.active_instances(inst_tab,inst_cont);Dbms_output.put_line(-|inst_tab.first);Dbms_output.put_line(to_char(inst_cont);ElseDbms_output.put_line(Not A Clustered Database);End if;End;第四，是否配置了DGSelect protection_mode,protection_level,remote_archive,database_role,dataguard_broker,guard_statusFrom v$database;第五，是否启用了归档模式Select log_mode From v$database;第六，是否启用了flashback database特性Select flashback_on from v$database; 7、是否起用了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;8、了解控制文件的组成 select * from v$controlfile;9、了解日志文件的组成 select l.group#, lf.type, lf.member, l.bytes, l.status LOG_STATUS, lf.status LOGFILE_STATUS from v$log l, v$logfile lf where l.group# = lf.group# order by 1,3;10、了解参数文件的组成和位置 show parameter spfile create spfile from pfile. create pfile from spfile; create spfile from memory; create pfile from memory;11、了解instance的相关信息 select instance_name, host_name, status, archiver, database_status, instance_role, active_state from v$instance;12、用户和密码相关 是否使用了缺省密码？ 是否使用了profile? 是否起用了密码验证函数？ 用户身份验证的方法？ 密码是否区分大小写等。 select name, value from gv$parameter where name = resource_limit; select profile, resource_name, limit from dba_profiles order by 1,2; select username, profile from dba_users where account_status = OPEN order by 1; select d.username, u.account_status from dba_users_with_defpwd d, dba_users u where d.username = u.username and account_status = OPEN order by 2,1;13、是否打开了BLOCK CHANGE TRACKING select filename, status, bytes from v$block_change_tracking;14、起用了那些特性(Feature)? DBMS_FEATURE_USAGE_REPORT15、表空间和数据文件的规划 这个大家都很熟悉，就不写了16、字符集相关 select * from database_properties;17、系统中是否存在invalid对象 select owner, object_type, COUNT(*) from dba_objects where status = INVALID group by owner, object_