Alter database open resetlogs error ORA-00349

After restore & recovery from RAC ASM to single instance (non ASM) I got error:

alter database open resetlogs

*

ERROR at line 1:

ORA-00349: failure obtaining block size for '+ASMDISK1/DW/onlinelog/redo_g1_a'

In alert.log:

Tue Oct 04 06:01:07 2011

Errors in file /oracle/admin/dw/udump/DW_ora_3115.trc:

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

ORA-00312: online log 4 thread 1: '+DISK1/DW/redo_g4_b'

ORA-17503: ksfdopn:2 Failed to open file +DISK1/DW/redo_g4_b

ORA-15173: entry 'redo_g4_b' does not exist in directory 'DW'

ORA-00312: online log 4 thread 1: '+DISK1/DW/redo_g4_a'

ORA-17503: ksfdopn:2 Failed to open file +DG01/DW/redo_g4_a

ORA-15173: entry 'redo_g4_a' does not exist in directory 'DW'

Reason:

Redo log locations are unknown to new Instance.

Solution:

Rename redo log locations from ASM 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.