Standby Failed to Startup during Grid Control - Data Guard Setup with ORA-07445 [kcrf_val_log_bsz()+534] (Doc ID 1321813.1)

Last updated on NOVEMBER 30, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
OMS and Management Agent Versions (on all Sites) are 11.1.0
RAC Primary and RAC Standby databases are at 11.2.0.2.


Symptoms


When tried to create standby duplicate from Gridcontrol that has
different Diskgroup Names.

OEM identifies that there is Grid Infrastructure installed on the target server, during the creation of  duplicate Standby database , the controlfile is transferred
and the creation continues, but when it tries to locate redo-logs it points
to the diskgroups on the primary side and the standby instance is terminated.
Hence the TNS-error in the output from OEM.
( ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor)

and then the standby failed to startup the standby database as mount and failed as
in the below alert log from Standby database:


Alert log from Standby database:

Wed Nov 10 09:22:51 2010
ARC3 started with pid=35, OS id=27926
Completed: alter database mount standby database
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4]
[PC:0x2149042, kcrf_val_log_bsz()+534] [flags: 0x0, count: 1]
Errors in file
/u01/app/oracle/diag/rdbms/dt0999elm7_1/DT09991/trace/DT09991_lgwr_27800.trc
(incident=12137):
ORA-07445: exception encountered: core dump [kcrf_val_log_bsz()+534]

[SIGSEGV] [ADDR:0x4] [PC:0x2149042] [Address not mapped to object] []
ORA-15001: diskgroup "ARCH_DT0999" does not exist or is not mounted
ORA-17503: ksfdopn:2 Failed to open file
+ARCH_DT0999/dt0999elm8_0/onlinelog/group_1.257.732276379
ORA-15001: diskgroup "ARCH_DT0999" does not exist or is not mounted
ORA-15001: diskgroup "ARCH_DT0999" does not exist or is not mounted
ORA-00312: online log 1 thread 1:
'+DATA_DT0999/dt0999elm8_0/onlinelog/group_1.257.732276377'
ORA-00312: online log 1 thread 1:
'+ARCH_DT0999/dt0999elm8_0/onlinelog/group_1.257.732276379'
ORA-00349: failure obtaining block size for
'+DATA_DT0999/dt0999elm8_0/onlinelog/group_1.257.732276377'
ORA-15001: diskgroup "DATA_DT0999" does not exist or is not mounted
ORA-17503: ksfdopn:2 Failed to open file
+DATA_DT0999/dt0999elm8_0/onlinelog/group_1.257.732276377
ORA-15001: diskgroup "DATA_DT0999" does not exist or is not mounted
ORA-15001: diskgroup "DATA_DT0999" does not exist or
Incident details in:
/u01/app/oracle/diag/rdbms/dt0999elm7_1/DT09991/incident/incdir_12137/DT09991_
lgwr_27800_i12137.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ARC3: Archival started



Changes

NA

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms