数据库升级与数据迁移实战分享-杨建荣.pdf

《数据库升级与数据迁移实战分享-杨建荣.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、数据库升级与数据迁移实战分享Amdocs杨建荣分享思路•数据库升级实战–严谨，细心，运气•数据迁移实战–挑战传统方法，艰难的技术推广升级目标10gR211gR210gR211gR210gR211gR210gR211gR211gR2FullSupportExtended11.2Jan2015201811.1Aug2012201510.2.0.5July20102015资源情况•2台服务器,单实例数据库4个,10gR2,T级•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•至少四轮以上的测试•开发测试部门,产品部规划•性能DBA,应用DBA,开发DBA•客户的DBA•Oracle的support升级可选方案手工升级流程图ORACLE_HOME10g切换ORACLE_HOME11gDBServerDBServer升级数据字典升级流程规划图9:5010:0010:3010:40PETUSG1PETMAE110:5011:0011:1011:

3、3011:4011:45AMPETCUS1PETAEM19:5010:0010:3010:5011:10并行1：PETCUS1PETUSG1并行2：PETAEM1PETMAE1升级中的挑战•过程需要完全可控•需要同时升级4个数据库实例•附加部分业务升级•3个小时内全部完成(1个小时的业务升级)•未知的突发情况升级前的准备安装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)"升级前的参数优化10g已有的隐含参数11g中过期的10g参数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升级前的参数优化•11g中新参数的选择•sec_case_sensitive_logon•sec_max_failed_login_attempts•result_cache_max_size•deferred_segment_creation•diagnostic_dest•db_unrecoverable_scn_tracking升级前的

8、检查selectsubstr(comp_name,1,40)comp_name,status,完整的系统备份(热备substr(version,1,10)versionfromdba_registry甚至冷