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

Last updated on JULY 20, 2024

Applies to:

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

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