数据库mount redo 长期出于clearing_current

数据库redo 长期处于CLEARING_CURRENT
状态
SQL>  select group#,archived,status from v$log;

    GROUP# ARC STATUS
---------- --- ----------------
         3 NO  CLEARING_CURRENT
         6 YES UNUSED
         5 YES UNUSED
         4 YES UNUSED

造成的原因：对mount的状态下clear  group
对当前的redo 组进行了此操作 alter database clear unarchived logfile group 3;

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

--当ORA-10039没有需要恢复

SQL> recover database until cancel ;
Media recovery complete.
SQL> alter database open resetlogs ;

Database altered.

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

    GROUP# ARC STATUS
---------- --- ----------------
         3 NO  CURRENT
         4 YES UNUSED
         5 YES UNUSED
         6 YES UNUSED

SQL> select name from v$datafile ;