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 11/15/2016 15:39:51 ORA-00392: log 3 of thread 1 is being cleared, operation not allowed ORA-00312: online log 3 thread 1: '/redo/orcl/ORCL/onlinelogs/redo03a.rdo' ORA-00312: online log 3 thread 1: '/oradata/orcl/ORCL/onlinelogs/redo03b.rdo'
SQL> select group#, status from v$log;
GROUP# STATUS ---------- ---------------- 1 CLEARING 2 CLEARING 5 CLEARING 4 CLEARING 3 CLEARING_CURRENT
Řešení
SQL> alter database clear unarchived logfile group 3;
Database altered.
SQL> select group#, status from v$log;
GROUP# STATUS ---------- ---------------- 1 INACTIVE 2 CURRENT 5 UNUSED 4 UNUSED 3 UNUSED
RMAN> alter database open resetlogs;
database opened