All 12c database instances crash with error ORA-29770 when remote site is powered off
Last updated on MARCH 19, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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 22.214.171.124, those instances were not affected.
This is a Extended RAC configuration, where customer is testing a site loss scenario.
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