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 Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL 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 session Wed Dec 03 10:16:38 2014 Errors 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.trc Slave exiting with ORA-600 exception Errors 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.trc Wed Dec 03 10:16:39 2014 Trace dumping is performing id=[cdmp_20141203101639] Recovery Slave PR0F previously exited with exception 600 MRP0: Background Media Recovery terminated with error 448 Errors in file /u01/app/oracle/diag/rdbms/cordys02/cordys02/trace/cordys02_pr00_18358.trc: ORA-00448: normal completion of background process
[oracle@cordys02 patches]$ cd 10419984 [oracle@cordys02 10419984]$ ls etc files README.html README.txt [oracle@cordys02 10419984]$ [oracle@cordys02 10419984]$ [oracle@cordys02 10419984]$ [oracle@cordys02 10419984]$ opatch apply Oracle Interim Patch Installer version 11.2.0.3.0 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.0 OUI version : 11.2.0.1.0 Log 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.log Applying 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 and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle 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]: y Please 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] y User Responded with: Y Backing up files... Patching component oracle.rdbms, 11.2.0.1.0... Verifying the update... Patch 10419984 successfully applied Log 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.log OPatch succeeded. [oracle@cordys02 10419984]$ [oracle@cordys02 10419984]$ [oracle@cordys02 10419984]$ opatch lsinvertory Oracle Interim Patch Installer version 11.2.0.3.0 Copyright (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 -fmw Please use the option 'opatch -help' to get correct syntax OPatch failed with error code 14 [oracle@cordys02 10419984]$ opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.0 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.0 OUI version : 11.2.0.1.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-12-03_11-22-47AM_1.log Lsinventory 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.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 10419984 : applied on Wed Dec 03 11:22:21 CST 2014 Unique Patch ID: 14007049 Created on 8 Sep 2011, 10:38:58 hrs PST8PDT Bugs fixed: 10419984 Patch 12419378 : applied on Wed Nov 26 11:43:21 CST 2014 Unique 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 session Attempt to start background Managed Standby Recovery process (cordys02) Wed Dec 03 11:24:37 2014 MRP0 started with pid=31, OS id=20977 MRP0: Background Managed Standby Recovery process started (cordys02) started logmerger process Wed Dec 03 11:24:42 2014 Managed Standby Recovery not using Real Time Apply Parallel Media Recovery started with 32 slaves Waiting for all non-current ORLs to be archived... All non-current ORLs have been archived. Media Recovery Waiting for thread 1 sequence 510 Completed: alter database recover managed standby database disconnect from session Wed Dec 03 11:24:46 2014 Using STANDBY_ARCHIVE_DEST parameter default value as /oradata/archlog/ RFS[1]: Assigned to RFS process 21045 RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 6251 RFS[1]: Opened log for thread 1 sequence 510 dbid -1114170009 branch 864585129 Archived Log entry 515 added for thread 1 sequence 510 rlc 864585129 ID 0xbd980de1 dest 2: Wed Dec 03 11:24:53 2014 Media Recovery Log /oradata/archlog/1_510_864585129.arc Media Recovery Waiting for thread 1 sequence 511 Wed Dec 03 11:24:58 2014
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。