I face with this issue when try to add standby file on standalone 11.2.0.1 database with ASM on AIX operating system:
Symptoms:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE
*
ERROR at line 1:
ORA-10878: parallel recovery slave died unexpectedly
Error in alert log:
error in alert:
Thu Jan 12 10:42:13 2012
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x0] [PC:0x100137314, kggibr()+52] [flags: 0x0, count: 1]
Errors in file /oracle11g/db/TEST/11.2.0/log/diag/rdbms/stby/STBY/trace/STBY_pr04_9830594.trc (incident=201896):
ORA-07445: exception encountered: core dump [kggibr()+52] [SIGSEGV] [ADDR:0x0] [PC:0x100137314] [Invalid permissions for mapped object] []
Solution:
ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE USING CURRENT LOGFILE DISCONNECT noparallel;
Referance:
Bug 9728806 – ORA-7445 [kggibr()+52] during recovery on IBM AIX POWER Systems [ID 9728806.8]
3 yorum
Comments feed for this article
Mayıs 21, 2012 12:26 pm
Laurent Schneider » Troubleshoot ORA-10878
[…] which will then in normal operation mode apply only one log at the time. Diggout out from Helios’s Blog Tags: Parallel Media Recovery Comments (0) Trackbacks (0) Leave a comment […]
Şubat 6, 2016 12:41 am
Kamal Sharma
Thanks a Lot !! Good documentation really helpful in real envirnoment
Şubat 8, 2016 11:31 am
Gunes Erol
Thank you Kamal…