ORA-00349: failure obtaining block size for ‘+REDOX’
Cause:
kIsH@x3z6zx9<^>!oerr ora 00349
00349, 00000, “failure obtaining block size for ‘%s'”
// *Cause: The operating system was unable to determine the blocksize
// for the given filename.
// *Action: Consult the accompanying error message, and correct the
// device or specify another filename.
kIsH@x3z6zx9<^>alter database add logfile group 4 '+REDOX' size 109M;
alter database add logfile group 4 '+REDOX' size 109M
*
ERROR at line 1:
ORA-00349: failure obtaining block size for '+REDOX'
Action:
Check if the disk is mounted or exist
[oracle@x3dbzx36 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 4194304 22320 88 0 88 0 N DATAX/
MOUNTED EXTERN N 512 4096 4194304 8928 8196 0 8196 0 N INDX/
MOUNTED EXTERN N 512 4096 4194304 14880 11060 0 11060 0 N RECOX/
Mount the diskgroup
SQL> alter diskgroup REDOX mount;
Diskgroup altered.
Add the file
kIsH@x3z6zx9<^>alter database add logfile group 4 '+REDOX' size 109M;
Database altered.