The following opinions expressed in this post are my own and in no way connected to my employer.
Issue:
ORA-00349: failure obtaining block size for '/redo/orcl/ORCL/onlinelogs/redo01a.rdo'
ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory
Additional information: 9
Solution:
If you are running into the above error, try to rename the log file or create a new one and clear the log file.
select group#,status,member from v$logfile;
alter database rename file '/redo/orcl/ORCL/onlinelogs/redo01a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo01a.rdo';
alter database clear logfile group 1;
select group#,thread#,status from v$log;
GROUP# THREAD# STATUS
---------- ---------- ----------------
1 1 CURRENT
2 1 UNUSED
5 1 UNUSED
4 1 UNUSED
3 1 UNUSED
Comments