資源描述：
《數(shù)據(jù)庫(kù)升級(jí)與數(shù)據(jù)遷移實(shí)戰(zhàn)分享-楊建榮.pdf》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫(kù)。
1、數(shù)據(jù)庫(kù)升級(jí)與數(shù)據(jù)遷移實(shí)戰(zhàn)分享Amdocs楊建榮分享思路?數(shù)據(jù)庫(kù)升級(jí)實(shí)戰(zhàn)–嚴(yán)謹(jǐn)，細(xì)心，運(yùn)氣?數(shù)據(jù)遷移實(shí)戰(zhàn)–挑戰(zhàn)傳統(tǒng)方法，艱難的技術(shù)推廣升級(jí)目標(biāo)10gR211gR210gR211gR210gR211gR210gR211gR211gR2FullSupportExtended11.2Jan2015201811.1Aug2012201510.2.0.5July20102015資源情況?2臺(tái)服務(wù)器,單實(shí)例數(shù)據(jù)庫(kù)4個(gè),10gR2,T級(jí)?Linux2.6.18-308.el5#1SMP–x86_64x86_64x86_64GNU/Linux?OSSoc
2、kets/Cores/CPUs：4/40/80–CPUmodelname:Intel(R)Xeon(R)CPUE7-4870@2.40GHz?OSMemory：346GB?至少四輪以上的測(cè)試?開發(fā)測(cè)試部門,產(chǎn)品部規(guī)劃?性能DBA,應(yīng)用DBA,開發(fā)DBA?客戶的DBA?Oracle的support升級(jí)可選方案手工升級(jí)流程圖ORACLE_HOME10g切換ORACLE_HOME11gDBServerDBServer升級(jí)數(shù)據(jù)字典升級(jí)流程規(guī)劃圖9:5010:0010:3010:40PETUSG1PETMAE110:5011:0011:1011:
3、3011:4011:45AMPETCUS1PETAEM19:5010:0010:3010:5011:10并行1：PETCUS1PETUSG1并行2：PETAEM1PETMAE1升級(jí)中的挑戰(zhàn)?過(guò)程需要完全可控?需要同時(shí)升級(jí)4個(gè)數(shù)據(jù)庫(kù)實(shí)例?附加部分業(yè)務(wù)升級(jí)?3個(gè)小時(shí)內(nèi)全部完成(1個(gè)小時(shí)的業(yè)務(wù)升級(jí))?未知的突發(fā)情況升級(jí)前的準(zhǔn)備安裝11gR2軟件，部署PSU./opatchlsinventoryInterimpatches(1):Patch16056267:appliedonThuOct0316:01:47ICT2013UniquePatchI
4、D:15994298Patchdescription:"DatabasePatchSetUpdate:11.2.0.2.10(16056267)"Createdon12Mar2013,10:08:56hrsPST8PDTSub-patch14727315;"DatabasePatchSetUpdate:11.2.0.2.9(14727315)"Sub-patch14275621;"DatabasePatchSetUpdate:11.2.0.2.8(14275621)"Sub-patch13923804;"DatabasePatchSet
5、Update:11.2.0.2.7(13923804)"Sub-patch13696224;"DatabasePatchSetUpdate:11.2.0.2.6(13696224)"升級(jí)前的參數(shù)優(yōu)化10g已有的隱含參數(shù)11g中過(guò)期的10g參數(shù)background_dump_destparameternameparametervaluecursor_space_for_time_optimizer_cost_modelCPUfast_start_io_target_optimizer_skip_scan_enabledFALSElog_a
6、rchive_local_first_optimizer_sortmerge_join_enabledFALSElog_archive_start_optimizer_use_feedbackFALSEmax_enabled_roles_optimizer_dynamic_sampling0_optimizer_join_elimination_enabledFALSEparallel_automatic_tuningparallel_adaptive_multi_userFALSEparallel_serverparallel_exe
7、cution_message_size65536parallel_server_instancesplsql_debugplsql_v2_compatibilityremote_os_authent升級(jí)前的參數(shù)優(yōu)化?11g中新參數(shù)的選擇?sec_case_sensitive_logon?sec_max_failed_login_attempts?result_cache_max_size?deferred_segment_creation?diagnostic_dest?db_unrecoverable_scn_tracking升級(jí)前的
8、檢查selectsubstr(comp_name,1,40)comp_name,status,完整的系統(tǒng)備份(熱備substr(version,1,10)versionfromdba_registry甚至冷
