Home » ORA-00344: unable to re-create online log

ORA-00344: unable to re-create online log

by tuanlp

💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00344 error.

RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 08/10/2015 09:53:07
ORA-00344: unable to re-create online log '/oradata/outdb/redo01.log'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

SOLUTION:

First, check the status of REDO LOGS.

SQL> select * from v$logfile;

    GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
         1 ONLINE /oradata/outdb/redo01.log NO
         2 ONLINE /oradata/outdb/redo02.log NO
         3 ONLINE /oradata/outdb/redo03.log NO
         4 ONLINE /oradata/outdb/redo04.log NO
         5 ONLINE /oradata/outdb/redo05.log NO
         6 ONLINE /oradata/outdb/redo06.log NO
         7 ONLINE /oradata/outdb/redo07.log NO
         8 ONLINE /oradata/outdb/redo08.log NO
         9 ONLINE /oradata/outdb/redo09.log NO
        10 ONLINE /oradata/outdb/redo10.log NO

Đổi đường dẫn redolog

alter database rename file '/home/oracle/ora/redo02.log' to 'D:\home\oracle\ora\redo02.log';
alter database rename file '/home/oracle/ora/redo03.log' to 'D:\home\oracle\ora\redo03.log';
alter database rename file '/home/oracle/ora/redo05.log' to 'D:\home\oracle\ora\redo05.log';
alter database rename file '/home/oracle/ora/redo07.log' to 'D:\home\oracle\ora\redo07.log';

Now no group is in clearing_current mode. Lets do resetlog again.

[oracle@otdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Aug 10 10:03:01 2015
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
SQL> alter database open resetlogs;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE

You may also like