資源描述:
《25 oracle dataguard 補丁升級11.2.0.4.0-11.2.0.4.3》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、ORACLEDATAGUARD打補丁一、升級步驟總覽1.將主庫切換為從庫進行升級1*準備新環(huán)境,搭建一套本地存儲的DATAGUARD2*主從切換,暫停新主庫向新從庫傳輸日志3*升級新從庫,升級后打開新主庫向新從庫傳輸日志,進行主從切換4*最后在升級的主庫上面進行registry并運行catbundle.sqlp完成最后升級配置2.對從庫進行升級與主庫升級相同二、升級步驟1.準備新環(huán)境,搭建一套本地存儲的DATAGUARD準備步驟略2.主從切換,暫停新主庫向新從庫傳輸日志1)查看主從狀態(tài)略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*關(guān)閉數(shù)據(jù)庫與監(jiān)聽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