首页 > 代码库 > Bug 10419984--FOR oracle 11.2.0.1 adg ora-600[kcbr_apply_change_11]

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


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

[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





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