Fix Redo log wrong location

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-00349: failure obtaining block size for '+REDO_UNDO/MYDB/ONLINELOG/group_13a.log'

ORA-15001: diskgroup "REDO_UNDO" does not exist or is not mounted

ORA-15001: diskgroup "REDO_UNDO" does not exist or is not mounted

ORA-15001: diskgroup "REDO_UNDO" does not exist or is not mounted

 

 

SQL> alter database rename file '+REDO_UNDO/MYDB/ONLINELOG/group_13a.log' to '+FRA/MYDB/ONLINELOG/group_13a.log';

 

Database altered.

 

SQL>  alter database open resetlogs;

 alter database open resetlogs

*

ERROR at line 1:

ORA-00392: log 13 of thread 1 is being cleared, operation not allowed

ORA-00312: online log 13 thread 1: '+FRA/MYDB/ONLINELOG/group_13a.log'

 

 

SQL> alter database clear unarchived logfile group 13;

 Database altered.

 

SQL> alter database open resetlogs;

Database altered.