Bug 10419984--FOR oracle 11.2.0.1 adg ora-600[kcbr_apply_change_11]

標籤：des   blog   http   io   ar   os   sp   for   on   

1:standby database :

SQL> select * from v$version;BANNER------------------------------------------------------------------------------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE    11.2.0.1.0      ProductionTNS for Linux: Version 11.2.0.1.0 - ProductionNLSRTL Version 11.2.0.1.0 - Production

2: when database open and apply log process begin....... alert showing belw:

Completed: alter database recover managed standby database disconnect from sessionWed Dec 03 10:16:38 2014Errors in file /u01/app/oracle/diag/rdbms/cordys02/cordys02/trace/cordys02_pr0f_18388.trc  (incident=22780):ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []Incident details in: /u01/app/oracle/diag/rdbms/cordys02/cordys02/incident/incdir_22780/cordys02_pr0f_18388_i22780.trcSlave exiting with ORA-600 exceptionErrors in file /u01/app/oracle/diag/rdbms/cordys02/cordys02/trace/cordys02_pr0f_18388.trc:ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []Errors in file /u01/app/oracle/diag/rdbms/cordys02/cordys02/trace/cordys02_mrp0_18356.trc  (incident=22652):ORA-00600: internal error code, arguments: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []Incident details in: /u01/app/oracle/diag/rdbms/cordys02/cordys02/incident/incdir_22652/cordys02_mrp0_18356_i22652.trcWed Dec 03 10:16:39 2014Trace dumping is performing id=[cdmp_20141203101639]Recovery Slave PR0F previously exited with exception 600MRP0: Background Media Recovery terminated with error 448Errors in file /u01/app/oracle/diag/rdbms/cordys02/cordys02/trace/cordys02_pr00_18358.trc:ORA-00448: normal completion of background process

3: on mos see Bug 10419984 ,need patching p10419984_112010_Linux-x86-64.zip

[[email protected] patches]$ cd 10419984[[email protected] 10419984]$ lsetc  files  README.html  README.txt[[email protected] 10419984]$ [[email protected] 10419984]$ [[email protected] 10419984]$ [[email protected] 10419984]$ opatch applyOracle Interim Patch Installer version 11.2.0.3.0Copyright (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    : 11.2.0.3.0OUI version       : 11.2.0.1.0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/10419984_Dec_03_2014_11_21_48/apply2014-12-03_11-21-47AM_1.logApplying interim patch '10419984' to OH '/u01/app/oracle/product/11.2.0/db_1'Verifying environment and performing prerequisite checks...All 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 http://www.oracle.com/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 ([Y]es, [N]o) [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|n]yUser Responded with: YBacking up files...Patching component oracle.rdbms, 11.2.0.1.0...Verifying the update...Patch 10419984 successfully appliedLog file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/10419984_Dec_03_2014_11_21_48/apply2014-12-03_11-21-47AM_1.logOPatch succeeded.[[email protected] 10419984]$ [[email protected] 10419984]$ [[email protected] 10419984]$ opatch lsinvertoryOracle Interim Patch Installer version 11.2.0.3.0Copyright (c) 2012, Oracle Corporation.  All rights reserved.Syntax Error... Unrecognized Command or Option (lsinvertory): 1st argument must be one of the following:   apply   napply   rollback   nrollback   lsinventory   lsinv   lspatches   query   util   prereq   version   -help   -help -fmwPlease use the option 'opatch  -help' to get correct syntaxOPatch failed with error code 14[[email protected] 10419984]$ opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.0Copyright (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    : 11.2.0.3.0OUI version       : 11.2.0.1.0Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-12-03_11-22-47AM_1.logLsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-03_11-22-47AM.txt--------------------------------------------------------------------------------Installed Top-level Products (1): Oracle Database 11g                                                  11.2.0.1.0There are 1 products installed in this Oracle Home.Interim patches (2) :Patch  10419984     : applied on Wed Dec 03 11:22:21 CST 2014Unique Patch ID:  14007049   Created on 8 Sep 2011, 10:38:58 hrs PST8PDT   Bugs fixed:     10419984Patch  12419378     : applied on Wed Nov 26 11:43:21 CST 2014Unique Patch ID:  13769952   Created on 8 Jul 2011, 02:47:43 hrs PST8PDT   Bugs fixed:     9068088, 9363384, 8865718, 8898852, 8801119, 9054253, 8725286, 8974548     9093300, 8909984, 8755082, 8780372, 9952216, 8664189, 8769569, 7519406     9302343, 9471411, 8822531, 7705591, 8650719, 10205230, 9637033, 8883722     8639114, 8723477, 8729793, 8919682, 8856478, 9001453, 8733749, 8565708     8735201, 8684517, 8870559, 8773383, 8981059, 8812705, 9488887, 12534742     8813366, 12534743, 9242411, 12534745, 12534746, 12534747, 8822832     12534748, 8897784, 8760714, 12534749, 8775569, 8671349, 8898589, 9714832     8642202, 9011088, 9369797, 9170608, 9165206, 8834636, 8891037, 8431487     8570322, 8685253, 8872096, 8718952, 8799099, 12534750, 9032717, 9399090     12534751, 12534752, 9713537, 9546223, 12534753, 12534754, 8588519     8783738, 12534755, 12534756, 8834425, 9454385, 8856497, 8890026, 8721315     10248516, 8818175, 8674263, 10249532, 9145541, 8720447, 9272086, 9467635     9010222, 9102860, 9197917, 8991997, 8661168, 8803762, 12419378, 8769239     9654983, 8706590, 8546356, 10408903, 8778277, 9058865, 8815639, 11724991     9971778, 9971779, 9027691, 9454036, 9454037, 9454038, 8761974, 9255542     9275072, 8496830, 8702892, 8818983, 8475069, 8875671, 9328668, 8891929     8798317, 9971780, 8782959, 8774868, 8820324, 8544696, 8702535, 9952260     9406607, 8268775, 9036013, 9363145, 8933870, 8405205, 9467727, 8822365     9676419, 11724930, 8761260, 8790767, 8795418, 8913269, 8717461, 8861700     9531984, 8607693, 8780281, 8330783, 8784929, 8780711, 9341448, 9015983     10323077, 8828328, 9119194, 10323079, 8832205, 8717031, 8665189, 9482399     9676420, 9399991, 8821286, 8633358, 9321701, 9655013, 9231605, 8796511     9167285, 8782971, 8756598, 8703064, 9390484, 9066116, 9007102, 9461782     10323080, 10323081, 10323082, 8753903, 8505803, 9382101, 9352237, 9216806     8918433, 11794163, 9057443, 8790561, 11794164, 8733225, 8795792, 11794165     11794167, 9067282, 8928276, 8837736, 9210925

4: then start standby database open and apply redolog

alter database recover managed standby database disconnect from sessionAttempt to start background Managed Standby Recovery process (cordys02)Wed Dec 03 11:24:37 2014MRP0 started with pid=31, OS id=20977 MRP0: Background Managed Standby Recovery process started (cordys02) started logmerger processWed Dec 03 11:24:42 2014Managed Standby Recovery not using Real Time ApplyParallel Media Recovery started with 32 slavesWaiting for all non-current ORLs to be archived...All non-current ORLs have been archived.Media Recovery Waiting for thread 1 sequence 510Completed: alter database recover managed standby database disconnect from sessionWed Dec 03 11:24:46 2014Using STANDBY_ARCHIVE_DEST parameter default value as /oradata/archlog/RFS[1]: Assigned to RFS process 21045RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 6251RFS[1]: Opened log for thread 1 sequence 510 dbid -1114170009 branch 864585129Archived Log entry 515 added for thread 1 sequence 510 rlc 864585129 ID 0xbd980de1 dest 2:Wed Dec 03 11:24:53 2014Media Recovery Log /oradata/archlog/1_510_864585129.arcMedia Recovery Waiting for thread 1 sequence 511Wed Dec 03 11:24:58 2014

Bug 10419984--FOR oracle 11.2.0.1 adg ora-600[kcbr_apply_change_11]