Sunday, January 30, 2011

alter database open resetlogs error ORA-00349

After restore & recovery I got error:

alter database open resetlogs
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'+ASMDG01/XXX/onlinelog/redo_g1_a'

in alert.log:

Sun Jan 30 06:01:07 2011
Errors in file /oracle/admin/XXX/udump/XXX_ora_3115.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '+DG01/XXX/redo_g4_b'
ORA-17503: ksfdopn:2 Failed to open file +DG01/XXX/redo_g4_b
ORA-15173: entry 'redo_g4_b' does not exist in directory 'XXX'
ORA-00312: online log 4 thread 1: '+DG01/XXX/redo_g4_a'
ORA-17503: ksfdopn:2 Failed to open file +DG01/XXX/redo_g4_a
ORA-15173: entry 'redo_g4_a' does not exist in directory 'XXX'


Solution:



rename redo log to existing location.


ALTER DATABASE RENAME FILE '+ASMDG01/XXX/onlinelog/redo_g1_a' TO '+DG01/XXX/redo_g1_a';

SQL> alter database open resetlogs;

Database altered.

SQL>

2 comments: