279
💡 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