DisplayAdd1

TechnoTechDB is a platform, which will help to grow your carrier in Information sector. Having 15 years of Experience in Oracle/MongoDB/Postgres/Mysql databases, along with having good expertise level of knowledge in Scripting to automate database task. Our goal to start with zero to hero level expertise in Database. You can access/refer my some blogs on https://mrorcldba.blogspot.com link and post your comments and your suggestion to motive us.

Saturday, 23 January 2016

ORA-07445: exception encountered: core dump [kcrf_val_log_bsz()+534] [SIGSEGV] [ADDR:0x4] [PC:0x214906E] [Address not mapped to object] []

Error --> during standby creation I got below error in RAC database.

after restore of standby controlfile, standby instance getting down with below error when executed  "ALTER DATABASE MOUNT"


ARC2: Becoming the active heartbeat ARCH
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x214906E, kcrf_val_log_bsz()+534] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/orcl/orcl_1/trace/orcl_1_lgwr_34167.trc  (incident=3785):
ORA-07445: exception encountered: core dump [kcrf_val_log_bsz()+534] [SIGSEGV] [ADDR:0x4] [PC:0x214906E] [Address not mapped to object] []
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/redo1b.log
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-00312: online log 1 thread 1: '+DG_FRA01/orcl/redo1a.log'
ORA-17503: ksfdopn:2 Failed to open file +DG_FRA01/orcl/redo1a.log
ORA-15173: entry 'redo1a.log' does not exist in directory 'orcl'
Incident details in: /opt/oracle/diag/rdbms/orcl/orcl_1/incident/incdir_3785/orcl_1_lgwr_34167_i3785.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Completed: alter database mount
Fri Jan 22 05:32:59 2016
Dumping diagnostic data in directory=[cdmp_20160122053259], requested by (instance=1, osid=34167 (LGWR)), summary=[incident=3785].



Cause : 

Might be log_file_name_convert is incorrect and not getting +DATA disk group on standby server.

Solution:

CHECK all Diskgroup name on Primary database and set correct log_file_name_convert parameter in Standby database.




No comments:

Post a Comment

Steps to Rename Host in Oracle RESTART (ASM) in Linux

  oracle@localhost ] asmcmd ASMCMD> lsdg State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_...