ORA-00349 ORA-27041 Linux-x86_64 Error: 2: No such file or directory

Scenario: We want to restore Oracle 11g RMAN backup into different host with different mount point.We have restore database and recover archive log as well. But when we want to open the database then we are getting the following error

Solution:

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/02/2014 19:13:54
ORA-00349: failure obtaining block size for '/u01/app/oracle/oradata/STLBAS/redo01.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9

RMAN>

ALTER DATABASE RENAME FILE '/u01/app/oracle/oradata/STLBAS/redo01.log' TO '/oracledb/oradata/stlbas/redo01.log';

SQL> alter database open resetlogs;


SQL>  alter database open resetlogs;
 alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1: '/oracledb/oradata/stlbas/redo01.log'


SQL> select group#, status from v$log;

    GROUP# STATUS
---------- ----------------
         1 CLEARING_CURRENT
         3 CLEARING
         2 CLEARING

SQL>

alter database clear logfile group 1;

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'/u01/app/oracle/oradata/STLBAS/redo02.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9
SQL>


SQL> ALTER DATABASE RENAME FILE '/u01/app/oracle/oradata/STLBAS/redo02.log' TO '/oracledb/oradata/stlbas/redo02.log';

Database altered.

SQL>

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'/u01/app/oracle/oradata/STLBAS/redo03.log'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9


SQL> ALTER DATABASE RENAME FILE '/u01/app/oracle/oradata/STLBAS/redo03.log' TO '/oracledb/oradata/stlbas/redo03.log';

Database altered.

SQL> alter database open resetlogs;

Database altered.