Activating a Physical Standby Database & it's Scenarios

Fix the ORA-00349: failure obtaining block size for '/REDOLOG/GANESH_DB/redo01.log'

 SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'+''/REDOLOG/GANESH_DB/redo01.log'
ORA-27041: unable to open file
HPUX-ia64 Error: 2: No such file or directory
Additional information: 9

OR : -

RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/31/2006 02:52:48
ORA-00349: failure obtaining block size for '+'/REDOLOG/GANESH_DB/redo01.log'

ROOT CAUSE :-

In Alert log if you getting below error like : - 

ORA-00313: open failed for members of log group 11 of thread 1

ORA-00312: online log 11 thread 1: '<path>\<Location>/onlinelog/redo01.log'

ORA-17503: ksfdopn:2 Failed to open file <path>\<Location>/onlinelog/redo01.log

ORA-15173: entry 'redo01.log' does not exist in directory 'onlinelog'

The error you're encountering with ORA-00349 and ORA-27041 occurs when attempting to open the database in resetlogs after restoring it; that is when we receive the above error. While running the same command (alter database open resetlogs;) in the SQL prompt ( ORA-00349, ORA-27041  )  or RMAN prompt ( RMAN-03002, ORA-00349 )  , If you're getting the above error as well .

This error occur because invalid or redolog location are different from source to target. So, If you have face same senario. Then clear the and drop the redologs of both online and standby.  

TROUBLESHOOT :-

Drop the online redolog and standby redolog ( SRL ). If the redolog are not drop then clear then again drop the redologs.  Click the below link for DROP and re-create the redolog in RAC and Standalone database.

https://oralcedbaganesh.blogspot.com/2024/08/fix-ora-00312ora-00312ora-17503-ora.html

ALTER DATABASE RENAME FILE '+'/REDOLOG/GANESH_DB/redo01.log' TO '<NEW_LOCATION>/redo01.log'; 

 

--------------------------------- Thanks for Reading ----------------------------------

If you face any issues related to database administration, feel free to write down your queries in the comments. I will do my best to resolve your issues and get back to you as soon as possible.