top of page
Writer's pictureblkrishnarao

ORA-00349: failure obtaining block size for '/redo/orcl/ORCL/onlinelogs/redo01a.rdo' | Oracle Database

Updated: Apr 16

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

149 views0 comments

Recent Posts

See All

Comments


bottom of page