My Oracle Support Banner

Data files created with "asynch_off" (Doc ID 2801553.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

Symptoms

All database settings point to asynch I/O. On one vm, datafiles have been created with asynch_on. But on an identical vm, datafiles have been created with asynch_off.

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
disk_asynch_io boolean TRUE
tape_asynch_io boolean TRUE
filesystemio_options string none

ASYNC_ON:
NAME ASYNCH_IO
-------------------------------------------------- ---------
+DATA/TEST/DATAFILE/system.257.1079923167 ASYNC_ON
+DATA/TEST/DATAFILE/sysaux.258.1079923171 ASYNC_ON
+DATA/TEST/DATAFILE/undotbs.259.1079923175 ASYNC_ON
+DATA/TEST/DATAFILE/app_data.260.1079923187 ASYNC_ON
+DATA/TEST/DATAFILE/app_idx.261.1079923449 ASYNC_ON
+DATA/TEST/DATAFILE/app_lob.262.1079923677 ASYNC_ON
+DATA/TEST/DATAFILE/sec_data.263.1079923711 ASYNC_ON

ASYNC_OFF:
NAME ASYNCH_IO
-------------------------------------------------- ---------
+DATA/TEST123/DATAFILE/system.257.1079297239 ASYNC_OFF
+DATA/TEST/DATAFILE/sysaux.258.1079297243 ASYNC_OFF
+DATA/TEST/DATAFILE/undotbs.259.1079297247 ASYNC_OFF
+DATA/TEST/DATAFILE/app_data.260.1079297259 ASYNC_OFF
+DATA/TEST/DATAFILE/app_idx.261.1079297521 ASYNC_OFF
+DATA/TEST/DATAFILE/app_lob.262.1079297749 ASYNC_OFF
+DATA/TEST/DATAFILE/sec_data.263.1079297783 ASYNC_OFF

Then, issue has been fixed after 19.11 patches applied.

NAME ASYNCH_IO
-------------------------------------------------- ---------
+DATA/TEST/DATAFILE/system.257.1079297239 ASYNC_ON
+DATA/TEST/DATAFILE/sysaux.258.1079297243 ASYNC_ON
+DATA/TEST/DATAFILE/undotbs.259.1079297247 ASYNC_ON
+DATA/TEST/DATAFILE/app_data.260.1079297259 ASYNC_ON


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.