DBV Can Not Access Online Datafiles (DBV-100) If FILESYSTEMIO_OPTIONS=SETALL
(Doc ID 360287.1)
Last updated on MARCH 12, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
IBM AIX on POWER Systems (64-bit)
1. Disks are mounted in normal mode (this means using AIX cache Filesystem and use asynchronous IO). If FILESYSTEMIO_OPTIONS=SetAll, then DBV against an online datafile fails with the following error:
DBV works fine on offline datafiles.
If FILESYSTEMIO_OPTIONS=none or FILESYSTEMIO_OPTIONS=asynch, then DBV works fine on online and offline data files
2. If disks are mounted in Direct I/O (DIO) ( -o dio mount option ) or in Concurrent I/O (CIO) ( -o cio mount option ) and FILESYSTEMIO_OPTIONS=SetAll, DBVERIFY works fine on online and offline datafiles when the datafiles are not in use by another process.
From <Bug 8555562>, closed as not a bug:
The main difference between DIO and CIO is concurrency. DIO on JFS2 does NOT allow concurrency on datafiles (so just one process can access the file), while CIO allow multiple readers /writers (explained in <Note 257338.1>). While database is in open status (instance started) dbwriter maintains open all datafiles so any other external process to instance cannot access datafiles.
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