Oracle----ORA-07445: exception encountered: core dump [kggibr()+52] [SIGSEGV] [ADDR:0x0] [PC:0x10013

Oracle 11201 DataGuard on AIX 6.1

standby database报错:

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x0] [PC:0x100137314, kggibr()+52] [flags: 0x0, count: 1]
Errors in file /oracle/app/oracle/diag/rdbms/wkapp51dr/wkapp51/trace/wkapp51_pr09_8585236.trc (incident=88265):
ORA-07445: exception encountered: core dump [kggibr()+52] [SIGSEGV] [ADDR:0x0] [PC:0x100137314] [Invalid permissions for mapped object] []
Incident details in: /oracle/app/oracle/diag/rdbms/wkapp51dr/wkapp51/incident/incdir_88265/wkapp51_pr09_8585236_i88265.trc
Sat Jul 23 18:23:33 2011
Trace dumping is performing id=[cdmp_20110723182333]
Sat Jul 23 18:23:35 2011
Sweep [inc][88265]: completed
Sweep [inc2][88265]: completed
Sat Jul 23 18:23:45 2011
Recovery Slave PR09 died
Sat Jul 23 18:23:46 2011
Errors with log /oraarch/wkapp51/wkapp51_757266953_1_36.arc
MRP0: Background Media Recovery terminated with error 448
Errors in file /oracle/app/oracle/diag/rdbms/wkapp51dr/wkapp51/trace/wkapp51_pr00_9633858.trc:
ORA-00448: normal completion of background process
Recovery interrupted!
Recovered data files to a consistent state at change 1846699
Errors in file /oracle/app/oracle/diag/rdbms/wkapp51dr/wkapp51/trace/wkapp51_pr00_9633858.trc:
ORA-00448: normal completion of background process
Errors in file /oracle/app/oracle/diag/rdbms/wkapp51dr/wkapp51/trace/wkapp51_mrp0_9699402.trc:
ORA-10878: parallel recovery slave died unexpectedly
MRP0: Background Media Recovery process shutdown (wkapp51)

Metalink:

Bug 9728806: MRP CRASHED ORA-07445 [KGGIBR()+52] KRP_NEXT_CV_FOR_APPLY KRP_SLAVE_APPLY_PENDI

Bug 9728806 ORA-7445 [kggibr()+52] during recovery on IBM AIX POWER Systems
This note gives a brief overview of bug 9728806.
The content was last updated on: 13-MAY-2011
Click here for details of each of the sections below.

Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 11.1 but BELOW 12.1
Versions confirmed as being affected 11.2.0.1
11.1.0.7

Platforms affected IBM AIX Power Based Systems (64bit)

Fixed:
This issue is fixed in 12.1 (Future Release)
11.2.0.2 (Server Patch Set)

Symptoms: Related To:
Process May Dump (ORA-7445) / Abend / Abort
ORA-10878 / ORA-16766
Dump in or under kggibr
Recovery

Description
ORA-7445 [kggibr()+52] during RECOVERY when platform is
IBM AIX on POWER Systems (64-bit). This bug is more commonly
seen in RDBMS version 11.2.0.1.

This is a fix to prevent a parallel recovery slave process
from crashing with an ORA-07445 during recovery.

Rediscovery Notes:
Look for all the following:
- a parallel recovery slave crashes with a ORA-07445 with
krp_next_cv_for_apply() on the stack
- for example in 11.2.0.1 on AIX the top of the crashed
process's stack looks like this:
-> krp_next_cv_for_apply() -> kggibr()+52 -> ORA-07445
- the recovery coordinator process (eg MRP on a standby
database) terminates recovery and writes the following
message to its tracefile:
ORA-10878: parallel recovery slave died unexpectedly
This error may also be accompanied by
ORA-16766 Redo Apply is stopped
- the memory model of the underlying platform is non-TSO
(eg AIX.PPC64)

Workaround:
Restart recovery or use serial recovery
eg: ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE USING CURRENT LOGFILE DISCONNECT noparallel;

HOOKS DUMP:kggibr ERROR:ORA-10878 ERROR:ORA-16766 LIKELYAFFECTS XAFFECTS_11.1.0.6 XAFFECTS_V11010006 AFFECTS=11.1.0.6 XAFFECTS_11.1.0.7 XAFFECTS_V11010007 AFFECTS=11.1.0.7 XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_DUMP TAG_P212 TAG_RECOVERY DUMP P212 RECOVERY FIXED_11.2.0.2 FIXED_12.1.0.0
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References
Bug:9728806 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26078027/viewspace-1052962/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26078027/viewspace-1052962/