Wednesday 2 April 2014

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.

1 comment:

  1. Jadwal Resmi Laga Ayam SV388 14 Maret 2019 - Kamis, 14 Maret 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Situs Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete