首页 > 代码库 > 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
[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]
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。