當(dāng)DBA面對(duì)新的環(huán)境.doc

首先了解當(dāng)前的oracle數(shù)據(jù)庫(kù)版本和平臺(tái)和相關(guān)信息這個(gè)很重要。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;第二，了解數(shù)據(jù)庫(kù)安裝了那些組件Col comp_name for a60Set linesize 150Select comp_name,version from dba_registry;第三，搞清楚當(dāng)前的環(huán)境是單機(jī)還是集群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和補(bǔ)充日志？ 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、了解參數(shù)文件的組成和位置 show parameter spfile create spfile from pfile. create pfile from spfile; create spfile from memory; create pfile from memory;11、了解instance的相關(guān)信息 select instance_name, host_name, status, archiver, database_status, instance_role, active_state from v$instance;12、用戶和密碼相關(guān) 是否使用了缺省密碼？ 是否使用了profile? 是否起用了密碼驗(yàn)證函數(shù)？ 用戶身份驗(yàn)證的方法？ 密碼是否區(qū)分大小寫(xiě)等。 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、是否打開(kāi)了BLOCK CHANGE TRACKING select filename, status, bytes from v$block_change_tracking;14、起用了那些特性(Feature)? DBMS_FEATURE_USAGE_REPORT15、表空間和數(shù)據(jù)文件的規(guī)劃 這個(gè)大家都很熟悉，就不寫(xiě)了16、字符集相關(guān) select * from database_properties;17、系統(tǒng)中是否存在invalid對(duì)象 select owner, object_type, COUNT(*) from dba_objects where status = INVALID group by owner, object_