25 oracle dataguard 补丁升级11.2.0.4.0-11.2.0.4.3.docx

ORACLE DATAGUARD 打补丁一、升级步骤总览1.将主库切换为从库进行升级1*准备新环境，搭建一套本地存储的DATAGUARD2*主从切换，暂停新主库向新从库传输日志3*升级新从库，升级后打开新主库向新从库传输日志，进行主从切换4*最后在升级的主库上面进行registry并运行catbundle.sqlp完成最后升级配置2.对从库进行升级与主库升级相同 二、升级步骤1.准备新环境，搭建一套本地存储的DATAGUARD准备步骤略2.主从切换，暂停新主库向新从库传输日志1）查看主从状态略2）主从切换1*主库切换为新从库2*从库切换为新主库3）暂停新主库向从库传输日志3. 升级新从库，升级后打开新主库向新从库传输日志，进行主从切换1）升级新从库1*查看当前新从库PSU号oraclezhouhao trace$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch/oraclezhouhao OPatch$ lscrs emdpatch.pl ocm opatch.bat opatchdiag.bat opatch.pl oplandocs jlib opatch opatchdiag opatch.ini opatchprereqsoraclezhouhao OPatch$ ./opatch versionOPatch Version: .4OPatch succeeded.oraclezhouhao OPatch$ ./opatch lsinventoryOracle Interim Patch Installer version .4Copyright (c) 2012, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.locOPatch version : .4OUI version : .0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-0 7-28_16-46-27PM_1.logLsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opat ch/lsinv/lsinventory2015-07-28_16-46-27PM.txt-Installed Top-level Products (1):Oracle Database 11g .0There are 1 products installed in this Oracle Home.There are no Interim patches installed in this Oracle Home.-OPatch succeeded.oraclezhouhao OPatch$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）oraclezhouhao OPatch$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBas eDir /tmp/185225096*将补丁PSU18522509打上oraclezhouhao OPatch$ ./opatch apply /tmp/18522509 Oracle Interim Patch Installer version .11Copyright (c) 2015, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.locOPatch version : .11OUI version : .0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatc h2015-07-29_09-20-21AM_1.logVerifying environment and performing prerequisite checks.OPatch continues with these patches: 17478514 18031668 18522509Do you want to proceed? y|nyUser Responded with: YAll checks passed.Provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. Easier for you if you use your MyOracle Support Email address/User Name.Visit /support/policies.html for details.Email address/User Name:You have not provided an email address for notification of security issues.Do you wish to remain uninformed of security issues (Yes, No) N: yPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.(Oracle Home = /u01/app/oracle/product/11.2.0/db_1)Is the local system ready for patching? y|nyUser Responded with: YBacking up files.Applying sub-patch 17478514 to OH /u01/app/oracle/product/11.2.0/db_1Patching component oracle.rdbms, .0.Patching component oracle.rdbms.rsf, .0.Patching component oracle.sdo, .0.Patching component oracle.sysman.agent, .5.Patching component oracle.xdk, .0.Patching component oracle.rdbms.dbscripts, .0.Patching component oracle.sdo.locator, .0.Patching component oracle.nlsrtl.rsf, .0.Patching component oracle.xdk.rsf, .0.Patching component oracle.rdbms.rman, .0.Verifying the update.Applying sub-patch 18031668 to OH /u01/app/oracle/product/11.2.0/db_1Patching component oracle.rdbms, .0.Patching component oracle.rdbms.rsf, .0.Patching component oracle.ldap.rsf, .0.Patching component oracle.rdbms.crs, .0.Patching component mon, .0.Patching component oracle.ldap.rsf.ic, .0.Patching component oracle.rdbms.deconfig, .0.Patching component oracle.rdbms.dbscripts, .0.Patching component oracle.rdbms.rman, .0.Verifying the update.Applying sub-patch 18522509 to OH /u01/app/oracle/product/11.2.0/db_1Patching component oracle.rdbms.rsf, .0.Patching component oracle.rdbms, .0.Patching component mon, .0.Patching component oracle.rdbms.rman, .0.Patching component oracle.rdbms.dbscripts, .0.Patching component oracle.rdbms.deconfig, .0.Verifying the update.OPatch found the word warning in the stderr of the make command.Please look at this stderr. You can re-run this make command.Stderr output:ins_emagent.mk:113: warning: overriding commands for target nmosudoins_emagent.mk:52: warning: ignoring old commands for target nmosudo/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target nmosudo/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target nmosudoComposite patch 18522509 successfully applied.OPatch Session completed with warnings.Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-29_09-20-21AM_1.logOPatch completed with warnings.7*检查Opatch是否已经完成oraclezhouhao OPatch$ ./opatch lsinventoryOracle Interim Patch Installer version .11Copyright (c) 2015, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.locOPatch version : .11OUI version : .0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-29_09-31-02AM_1.logLsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-07-29_09-31-02AM.txt-Local Machine Information:Hostname: zhouhaoARU platform id: 226ARU platform description: Linux x86-64Installed Top-level Products (1):Oracle Database 11g .0There are 1 products installed in this Oracle Home.Interim patches (1) :Patch 18522509 : applied on Wed Jul 29 09:27:36 CST 2015Unique Patch ID: 17604597Patch description: Database Patch Set Update : .3 (18522509) Created on 30 Jun 2014, 08:14:42 hrs PST8PDTSub-patch 18031668; Database Patch Set Update : .2 (18031668)Sub-patch 17478514; Database Patch Set Update : .1 (17478514) Bugs fixed: 17752995, 17288409, 16392068, 17205719, 17811429, 17767676, 17614227 17040764, 17381384, 17754782, 17726838, 13364795, 17311728, 17389192 17006570, 17612828, 17284817, 17441661, 13853126, 17721717, 13645875 18203837, 17390431, 16542886, 16992075, 16043574, 17446237, 16863422 14565184, 17071721, 17610798, 17468141, 17786518, 17375354, 17397545 18203838, 16956380, 17478145, 16360112, 17235750, 17394950, 13866822 17478514, 17027426, 12905058, 14338435, 16268425, 13944971, 18247991 14458214, 16929165, 17265217, 13498382, 17786278, 17227277, 17546973 14054676, 17088068, 16314254, 17016369, 14602788, 17443671, 16228604 16837842, 17332800, 17393683, 13951456, 16315398, 18744139, 17186905 16850630, 17437634, 19049453, 17883081, 15861775, 17296856, 18277454 16399083, 16855292, 18018515, 10136473, 16472716, 17050888, 17865671 17325413, 14010183, 18554871, 17080436, 16613964, 17761775, 16721594 17588480, 17551709, 17344412, 18681862, 15979965, 13609098, 18139690 17501491, 17239687, 17752121, 17602269, 18203835, 17297939, 17313525 16731148, 17811456, 14133975, 17600719, 17385178, 17571306, 16450169 17655634, 18094246, 17892268, 17165204, 17011832, 17648596, 16785708 17477958, 16180763, 16220077, 17465741, 17174582, 18522509, 16069901 16285691, 17323222, 18180390, 17393915, 16875449, 18096714, 17238511 17596908, 17811438, 17811447, 18031668, 16912439, 18061914, 17622427 17545847, 16943711, 17082359, 17346671, 18996843, 14852021, 17783588 16618694, 17672719, 17614134, 17341326, 17546761, 17716305-OPatch succeeded.8* opatch lspatchesoraclezhouhao OPatch$ ./opatch lspatches18522509;Database Patch Set Update : .3 (18522509)OPatch succeeded.9*开启监听与DBoraclezhouhao OPatch$ lsnrctl startLSNRCTL for Linux: Version .0 - Production on 29-7 -2015 09:33:42Copyright (c) 1991, 2013, Oracle. All rights reserved.Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait.TNSLSNR for Linux: Version .0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/liste ner.oraLog messages written to /u01/app/oracle/diag/tnslsnr/zhouhao/listener/alert/log. xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhouhao)(PORT=1521)Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zhouhao)(PORT=1521)STATUS of the LISTENER-Alias LISTENERVersion TNSLSNR for Linux: Version .0 - ProductionStart Date 29-7 -2015 09:33:42Uptime 0 days 0 hr. 0 min. 1 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/list ener.oraListener Log File /u01/app/oracle/diag/tnslsnr/zhouhao/listener/alert/lo g.xmlListening Endpoints Summary. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhouhao)(PORT=1521) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)Services Summary.Service uptest has 1 instance(s). Instance uptest, status UNKNOWN, has 1 handler(s) for this service.The command completed successfullyoraclezhouhao OPatch$oraclezhouhao OPatch$oraclezhouhao OPatch$oraclezhouhao OPatch$ lsnrctl statusLSNRCTL for Linux: Version .0 - Production on 29-7 -2015 09:33:48Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zhouhao)(PORT=1521)STATUS of the LISTENER-Alias LISTENERVersion TNSLSNR for Linux: Version .0 - ProductionStart Date 29-7 -2015 09:33:42Uptime 0 days 0 hr. 0 min. 5 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/list ener.oraListener Log File /u01/app/oracle/diag/tnslsnr/zhouhao/listener/alert/lo g.xmlListening Endpoints Summary. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zhouhao)(PORT=1521) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)Services Summary.Service uptest has 1 instance(s). Instance uptest, status UNKNOWN, has 1 handler(s) for this service.The command completed successfullyoraclezhouhao OPatch$oraclezhouhao OPatch$oraclezhouhao OPatch$oraclezhouhao OPatch$ sqlplus / as sysdbaSQL*Plus: Release .0 Production on 7 29 09:33:53 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL startup;ORACLE instance started.Total System Global Area 1603411968 bytesFixed Size 2253664 bytesVariable Size 1006636192 bytesDatabase Buffers 587