25 oracle dataguard 补丁升级11.2.0.4.0-11.2.0.4.3

《25 oracle dataguard 补丁升级11.2.0.4.0-11.2.0.4.3》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、ORACLEDATAGUARD打补丁一、升级步骤总览1.将主库切换为从库进行升级1*准备新环境，搭建一套本地存储的DATAGUARD2*主从切换，暂停新主库向新从库传输日志3*升级新从库，升级后打开新主库向新从库传输日志，进行主从切换4*最后在升级的主库上面进行registry并运行catbundle.sqlp完成最后升级配置2.对从库进行升级与主库升级相同二、升级步骤1.准备新环境，搭建一套本地存储的DATAGUARD准备步骤略2.主从切换，暂停新主库向新从库传输日志1）查看主从状态略2）主从切换1*主库切换为新从库2*从库切换为新主库3）暂停新主库向从库传输日志3.升级

2、新从库，升级后打开新主库向新从库传输日志，进行主从切换1）升级新从库1*查看当前新从库PSU号[oracle@zhouhaotrace]$cd/u01/app/oracle/product/11.2.0/db_1/OPatch/[oracle@zhouhaoOPatch]$lscrsemdpatch.plocmopatch.batopatchdiag.batopatch.ploplandocsjlibopatchopatchdiagopatch.iniopatchprereqs[oracle@zhouhaoOPatch]$./opatchversionOPatchVersi

3、on:11.2.0.3.4OPatchsucceeded.[oracle@zhouhaoOPatch]$./opatchlsinventoryOracleInterimPatchInstallerversion11.2.0.3.4Copyright(c)2012,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/oracle/product/11.2.0/db_1CentralInventory:/u01/app/oraInventoryfrom:/u01/app/oracle/product/11.2.0/db

4、_1/oraInst.locOPatchversion:11.2.0.3.4OUIversion:11.2.0.4.0Logfilelocation:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-28_16-46-27PM_1.logLsinventoryOutputfilelocation:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-07-28_16-46-27PM.txt

5、--------------------------------------------------------------------------------InstalledTop-levelProducts(1):OracleDatabase11g11.2.0.4.0Thereare1productsinstalledinthisOracleHome.TherearenoInterimpatchesinstalledinthisOracleHome.------------------------------------------------------------

6、--------------------OPatchsucceeded.[oracle@zhouhaoOPatch]$2*关闭数据库与监听3*上传OPatch与PSU包p6880880_112000_Linux-x86-64.zip解压出OPatch目录p18522509_112040_Linux-x86-64.zip解压出18522509目录4*首先升级OPatch把最新的OPatch更新到oracle用户的$ORACLE_HOME5*检查当前是否已安装整改要求的补丁包（检查是否有与18522509有冲突的PSU）[oracle@zhouhaoOPatch]$./opat

7、chprereqCheckConflictAgainstOHWithDetail-phBaseDir/tmp/185225096*将补丁PSU18522509打上[oracle@zhouhaoOPatch]$./opatchapply/tmp/18522509OracleInterimPatchInstallerversion11.2.0.3.11Copyright(c)2015,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/oracle/produ