Problém

RMAN> alter database open resetlogs;
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-03002: failure of alter db command at 10/25/2016 06:40:10
 ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
 ORA-00312: online log 1 thread 1: '/redo/orcl/ORCL/onlinelogs/redo01a.rdo'
 ORA-00312: online log 1 thread 1: '/oradata/orcl/ORCL/onlinelogs/redo01b.rdo'

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

GROUP# THREAD# STATUS
 ---------- ---------- ----------------
 1 1 CLEARING_CURRENT
 2 1 CLEARING
 5 1 CLEARING
 4 1 CLEARING
 3 1 CLEARING
 SQL> alter database clear unarchived logfile group 1;
 alter database clear unarchived logfile group 1
 *
 ERROR at line 1:
 ORA-00349: failure obtaining block size for
 '/redo/orcl/ORCL/onlinelogs/redo01a.rdo'
 ORA-27041: unable to open file
 Linux-x86_64 Error: 2: No such file or directory
 Additional information: 9
 SQL> alter database clear logfile group 1;
 alter database clear logfile group 1
 *
 ERROR at line 1:
 ORA-00349: failure obtaining block size for
 '/redo/orcl/ORCL/onlinelogs/redo01a.rdo'
 ORA-27041: unable to open file
 Linux-x86_64 Error: 2: No such file or directory
 Additional information: 9

Řešení

SQL> select group#,status,member from v$logfile;

GROUP# STATUS MEMBER
 --------------------------------------------------------------------------------
 4 /redo/orcl/ORCL/onlinelogs/redo04a.rdo
 4 /oradata/orcl/ORCL/onlinelogs/redo04b.rdo
 1 /redo/orcl/ORCL/onlinelogs/redo01a.rdo
 1 /oradata/orcl/ORCL/onlinelogs/redo01b.rdo
 2 /redo/orcl/ORCL/onlinelogs/redo02a.rdo
 2 /oradata/orcl/ORCL/onlinelogs/redo02b.rdo
 3 /redo/orcl/ORCL/onlinelogs/redo03a.rdo
 3 /oradata/orcl/ORCL/onlinelogs/redo03b.rdo
 5 /redo/orcl/ORCL/onlinelogs/redo05a.rdo
 5 /oradata/orcl/ORCL/onlinelogs/redo05b.rdo
 10 rows selected.

alter database rename file '/redo/orcl/ORCL/onlinelogs/redo01a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo01a.rdo';
 alter database rename file '/redo/orcl/ORCL/onlinelogs/redo02a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo02a.rdo';
 alter database rename file '/redo/orcl/ORCL/onlinelogs/redo03a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo03a.rdo';
 alter database rename file '/redo/orcl/ORCL/onlinelogs/redo04a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo04a.rdo';
 alter database rename file '/redo/orcl/ORCL/onlinelogs/redo05a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo05a.rdo';

SQL> alter database rename file '/redo/orcl/ORCL/onlinelogs/redo01a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo01a.rdo';
 Database altered.

SQL> alter database rename file '/redo/orcl/ORCL/onlinelogs/redo02a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo02a.rdo';
 Database altered.

SQL> alter database rename file '/redo/orcl/ORCL/onlinelogs/redo03a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo03a.rdo';
 alter database rename file '/redo/orcl/ORCL/onlinelogs/redo04a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo04a.rdo';
 Database altered.
 SQL>
 Database altered.

SQL> alter database rename file '/redo/orcl/ORCL/onlinelogs/redo05a.rdo' to '/oradata/orcl/ORCL/onlinelogs/redo05a.rdo';
 Database altered.

SQL> alter database clear logfile group 1;
 Database altered.

SQL> alter database clear logfile group 2;
 alter database clear logfile group 3;
 alter database clear logfile group 4;
 alter database clear logfile group 5;

Database altered.
 SQL>
 Database altered.
 SQL>
 Database altered.
 SQL>
 Database altered.

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

GROUP# THREAD# STATUS
 ---------- ---------- ----------------
 1 1 CURRENT
 2 1 UNUSED
 5 1 UNUSED
 4 1 UNUSED
 3 1 UNUSED

Komentáře