Skip to Content
0
Jan 28, 2011 at 09:49 AM

FILESYSTEMIO_OPTIONS under Oracle 11.2.0.2 on AIX 6.1

588 Views

Hello Friends,

first I have updated a sandbox from oracle 11.2.0.4 to 11.2.0.1 and everything works fine.

But now I have installed patchset 11.2.0.2 and with unchanged mountoptions (cio) for sapdata-dirs and FILESYSTEMIO_OPTIONS=SETALL (unchanged too) I can't access the datafiles on os level for online backup (without RMAN) while the database is running. Error "A system call received a parameter that is not valid" is shown when using cp or dd. If I shutdown the database I can copy the files (very slow, due to the cio-mount option)

Only when I set the FILESYSTEMIO_OPTIONS to ASYNCH it is possible to do access the files when the system is online.

Has anybody of you a hint to resolve this issue?

Thanx in advance ...

Reinhard Koch