All 12c database instances crash with error ORA-29770 when remote site is powered off
(Doc ID 2090697.1)
Last updated on FEBRUARY 13, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
1. This is a RAC extended configuration with two sites (Eg Site A and B).
2. During a site loss test, customer powers off the machines and storage array from a remote site (Eg site B).
3. In the surviving nodes (site A), all the 12c DB instances crash with ORA-29770 when the remote site is powered off:
CKPT (ospid: 19091) waits for event 'enq: XR - database force logging' for 78 secs.
Fri Oct 16 20:13:42 2015
LGWR (ospid: 19082) waits for event 'log file parallel write' for 75 secs.
Fri Oct 16 20:14:15 2015
Dumping diagnostic data in directory=[cdmp_20151016201415], requested by (instance=5, osid=18628 (LMHB)), summary=[abnormal instance termination].
Fri Oct 16 20:14:18 2015
LMON (ospid: 18896) waits for event 'control file parallel write' for 86 secs.
Errors in file <PATH>//trace/INST1_lmhb_19011.trc (incident=984698):
ORA-29770: global enqueue process LMON (OSID 18896) is hung for more than 70 seconds
4. Customer had in the same cluster a DB 184.108.40.206, those instances were not affected.
This is a Extended RAC configuration, where customer is testing a site loss scenario.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document