goofys
goofys copied to clipboard
ORA-27072: File I/O error Linux-x86_64 Error: 95: Operation not supported
I am trying to backup database using RMAN, I mounted Azure blob storage container using goofys on my DB server and tried to run backup, got this:
RMAN-03009: failure of backup command on disk1 channel at 04/30/2022 20:17:09
ORA-19502: write error on file "/dbbackup/790s9423_1257_1_1", block number 1 (block size=16384)
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 1
Additional information: 4294967295
After that tried to create a text file from oracle user using touch a
, it succeeded.
Also tried to create a parameter file from sqlplus (note the parameter file was in text format), it succeeded.
But when I tried to create binary file from database, it failed:
SQL> create spfile='/dbbackup/spfile' from pfile='/dbbackup/pfile';
create spfile='/dbbackup/spfile' from pfile='/dbbackup/pfile'
*
ERROR at line 1:
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 1
Additional information: 4294967295
ORA-01078: failure in processing system parameters
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 1
Additional information: 4294967295
ORA-27072: File I/O error
Linux-x86_64 Error: 95: Operation not supported
Additional information: 4
Additional information: 3
Additional information: 4294967295
Is not goofys supported with Oracle database?
My fstab entries is the following:
/usr/bin/goofys#wasb://[email protected] /dbbackup fuse _netdev,allow_other,--file-mode=0777,--dir-mode=0777,--uid=3001,--gid=2000 0 0
I think the problem is not file type but how oracle db write the file.
Goofys does not support random write or file append operations, which I think that's what your application does. Can you verify the write pattern of your application to see if it really is the case?