厦门网站制作费用明细,网站免备案空间,工具类网站做排名,分析对手网站主要有以下的步骤 #xff1a;1.new ORACLE_HOME(11g), old ORACLE_HOME (10g)--这些需要提前提供给客户#xff0c;作为基本的约定2.install oracle software 11.2.0.2.0 on production--总共有7个DB,时间很紧#xff0c;所以准备要充分3.apply DB patch additional if nee…主要有以下的步骤 1.new ORACLE_HOME(11g), old ORACLE_HOME (10g)--这些需要提前提供给客户作为基本的约定2.install oracle software 11.2.0.2.0 on production--总共有7个DB,时间很紧所以准备要充分3.apply DB patch additional if needed--patch详细信息参见 Note:16056267.811.2.0.2.10 (Apr 2013) Database Patch Set Update (PSU) Patch:160562674.init parameter tuning--这个也是必需的主要有三个方面11g里面可能过期的参数如user_dump......11g里面新增加的参数如diag....,有些需要考虑是否调优。10g里面调优的隐含参数是否需要保留...5.OS kernel tuning--系统级的调优也是必须的。需要找专门的team来提供意见。6.PET and Production compare--准生产环境的准备需要做足前期的测试工作。7.confirm details with App team if have any concern.--对于升级过程中的部分问题如果不能确认需要找开发或者其他的team来协调。8.full backup or cold backup--这个取决于具体的环境实施方案保证充足的备份很重要生产系统做cold backup应该很悬了。9.check if there are crontab running or scheduled.--这个需要提前考虑一般的项目都会有系统监控要保证在升级过程中排除不必要的影响。如果有goldengate同步之类的也需要提前协调好保证不会影响。10.check if all database components are valid--可以使用如下的sql来select substr(comp_name,1,40) comp_name, status,substr(version,1,10) version from dba_registryorder by comp_name; --组建都应该是valid状态。11.check if all objects are valid--检查object状态也应该是valid.if there are component or objects invalid, need to use utlrp.sqlto recompile12.check if duplicate objects owned by SYS and SYSTEM Schema--从dba_objects里查询保证sys,system下的没有重复的object,以下是期望的结果如果有其他的需要查看metalink文档来处理。Note,1030426.6OBJECT_NAME OBJECT_TYPE------------------------------ -------------------AQ$_SCHEDULES TABLEAQ$_SCHEDULES_PRIMARY INDEXDBMS_REPCAT_AUTH PACKAGEDBMS_REPCAT_AUTH PACKAGE BODY13.disable custom triggers--为了排除trigger的导致的ddl影响建议还是disable custom trigger.14.Copy Pre-upgrade Information script. to a local folder--建一个临时的文件夹把升级所需的脚本拷贝过去。如脚本rdbms/admin/utlu112i.sql 需要从11ghome下rdbms/admin提前拷贝过去。15.Run Pre-upgrade Information Tool on target database (10g)--spool一下做升级前的检查工作。sqlplus / as sysdbaspool pre_upgrade_info.logutlu112i.sqlspool off16.Check the output of the Pre-Upgrade Information Tool--这里需要注意warning信息清空recyclebin,保证timezone file必须是v4,要不升级100%失败。还有要注意部分参数根据提示进行修改。17.backup /etc/oratab,tnsnames.ora,listener.ora sqlnet.ora,password file, pfile,spfile,profile--备份必要的文件作为rollback的备份。18.Copy Network files to 11g Home and modify the home in listener--拷贝tnsnames.ora,listener.ora到11g home的对应目录下。19.Copy password file to 11g Home--拷贝密码文件20.Prepare a separate .bash_profile to set 11g environment variables--profile文件也需要做相应修改。21.Collect dictionary stats--使用如下的包来EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;22.Stop Listener services of the target database.--停掉监听开始升级23.Shutdown the target database (10g)--down掉数据库清空缓存这样起来以后跑脚本会排出很多干扰速度也快一些。24.Set working environment to 11g ORACLE_HOME. Make sure multiple ORACLE HOMEs are not in the PATH variable.25.Copy spfile to 11g home.26.stop source(10g) DB,Start the db in nomount,mount mode, and make necessary changes/adjustments in spfile with scopespfile.--这一步需要修改compatible参数调节一些参数。(之前的步骤进行参数调优的时候准备好的)最后create spfile from pfile;27.Shutdown and startup the db in upgrade mode.--启动数据库,使用spfile,--startup upgrade28.Run upgrade script. Exit the session after upgrade.--这个是最关键的脚本运行时间也会长一些。,脚本运行完成后会自动shutfdown immediatespool upgrade11g2.log?/rdbms/admin/catupgrd.sqlSpool offExit29.Verify the log for errors. Ignore “table or view not found” errors--如果有部分错误需要检查如果有些错误如memory issue 不能忽略需要重新运行脚本30.Startup the db in normal mode and run post upgrade information tool. Verify the status of each db component and address the failures.--启动数据库运行如下的脚本。spool post_upgrade_info.txt?/rdbms/admin/utlu112s.sqlSpool31.Continue upgrade (new in 11g)--继续执行脚本属于post upgrade脚本。Spool upgrade11g2.log?/rdbms/admin/catuppst.sqlSpool off32.Recompile invalid objects33.enable custom triggers--enable之前disable的trigger34.update /etc/oratab with 11g home--更改该配置在某些应用中会用到。35.rename spfile/pfile from 10g home--保证10g的参数不被使用保证不会有错误的操作导致不必要的麻烦。36.Start Listener services of the target database with 11g HOME.--确定后启动监听。37.DBA sanity check(check if mv is able to refresh,db components are valid,check if there are ORA erros from logs)--DBA先做一些简单的sanity test.保证环境交给客户之前不会有基本的错误。38.Check the connectivity from client--然后从客户端进行测试连接是否正常。39.Backup of DB after upgrade--进行必要的备份。40.upgrade rman catalog if necessary--如果使用rman做备份恢复需要升级catalog41.change crontab
