DBV Can Not Access Online Datafiles (DBV-100) If FILESYSTEMIO_OPTIONS=SETALL
Last updated on SEPTEMBER 10, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 10-Sep-2014***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms