Bug 10419984--for Oracle 11.2.0.1 ADG Ora-600[kcbr_apply_change_11]

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 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/ora Cle/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/rdb ms/cordys02/cordys02/incident/incdir_22652/cordys02_mrp0_18356_i22652.trcwed Dec 10:16:39 2014Trace dumping is performing id=[cdmp_20141203101639]recovery Slave pr0f previously exit Ed with exception 600mrp0:background Media Recovery terminated with error 448Errors in File/u01/app/oracle/diag/rdbms/co Rdys02/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[[em Ail protected] 10419984]$ [[email protected] 10419984]$ [[email protected] 10419984]$ [[email    Protected] 10419984]$ opatch applyoracle interim Patch Installer version 11.2.0.3.0Copyright (c), Oracle Corporation. All rights reserved. Oracle Home:/u01/app/oracle/product/11.2.0/db_1central Inventory:/u01/app/orainventory from:/u01/a Pp/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 your myoracle support Email address/user name.visit http://www.oracle.com/support/policies. HTML for details. Email Address/user Name:you has not provided a email address for notification of security issues. Do your wish to remain uninformed of security issues ([Y]es, [N]o] [N]: Yplease shutdown Oracle instances running out of t His oracle_home is 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), Oracle Corporation. All rights reserved. Syntax Error ... Unrecognized Command or Option (lsinvertory): 1st argument must be one of the following:apply napply rollback NRO Llback lsinventory lsinv lspatches query util prereq version-help-help-fmwplease use the option ' Opat Ch-help ' to get correct Syntaxopatch failed with error code 14[[email protected] 10419984]$ opatch lsinventoryoracl  E interim Patch Installer version 11.2.0.3.0Copyright (c), Oracle Corporation. All rights reserved. Oracle Home:/u01/app/oracle/product/11.2.0/db_1central Inventory:/u01/app/orainventory from:/u01/a Pp/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 is 1 products installed in this Oracle Home.interim patches (2):P a Tch 10419984:applied on Wed Dec 11:22:21 CST 2014Unique Patch id:14007049 Created on 8 Sep, 10:38:58 HR s PST8PDT Bugs fixed:10419984patch 12419378:applied on Wed Nov 11:43:21 CST 2014Unique Patch id:1376995 2 Created on 8 Jul, 02:47:43 hrs pst8pdt Bugs fixed:9068088, 9363384, 8865718, 8898852, 8801119, 9054253, 87 25286, 8974548 9093300, 8909984, 8755082, 8780372, 9952216, 8664189, 8769569, 7519406 9302343, 9471411, 8822531, 7     705591, 8650719, 10205230, 9637033, 8883722 8639114, 8723477, 8729793, 8919682, 8856478, 9001453, 8733749, 8565708 8735201, 8684517, 8870559, 8773383, 8981059, 8812705, 9488887, 12534742 8813366, 12534743, 9242411, 12534745, 1253474    6, 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, 12534 752, 9713537, 9546223, 12534753, 12534754, 8588519 8783738, 12534755, 12534756, 8834425, 9454385, 8856497, 8890026, 87  21315 10248516, 8818175, 8674263, 10249532, 9145541, 8720447, 9272086, 9467635 9010222, 9102860, 9197917, 8991997, 8661168, 8803762, 12419378, 8769239 9654983, 8706590, 8546356, 10408903, 8778277, 9058865, 8815639, 11724991 9971 778, 9971779, 9027691, 9454036, 9454037, 9454038, 8761974, 9255542 9275072, 8496830, 8702892, 8818983, 8475069, 887567 1, 9328668, 8891929 8798317, 9971780, 8782959, 8774868, 8820324, 8544696, 8702535, 9952260 9406607, 8268775, 90360 13, 9363145, 8933870, 8405205, 9467727, 8822365 9676419, 11724930, 8761260, 8790767, 8795418, 8913269, 8717461, 886170 0 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 8918 433, 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 recover Y process (CORDYS02) Wed Dec 11:24:37 2014mrp0 started with pid=31, OS id=20977 mrp0:background Managed Standby Recover  Y process started (CORDYS02) started Logmerger processwed Dec 11:24:42 2014Managed Standby Recovery not using Real time Applyparallel Media Recovery started with + slaveswaiting for all non-current orls to be archived ... All Non-current Orls has been archived.  Media Recovery waiting for thread 1 sequence 510completed:alter database recover managed standby database disconnect from  sessionwed Dec 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 th Read 1 sequence 510 dbid-1114170009 branch 864585129Archived LOG entry 515 added for thread 1 sequence 510 RLC 864585129 ID 0Xbd980de1 dest 2:wed Dec 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]