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.

Leave a Reply