SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 3 thread 1: '/data/bkuptest/redo03a.log'
ORA-00312: online log 3 thread 1: '/data/bkuptest/redo03b.log'
Solution
SQL> select group#, status from v$log;
GROUP# STATUS
---------- ----------------
1 CLEARING
2 CLEARING
5 CLEARING
4 CLEARING
3 CLEARING_CURRENT
SQL>
SQL> alter database clear logfile group 1;
Database altered.
SQL> alter database clear logfile group 2;
Database altered.
SQL> alter database clear logfile group 3;
Database altered.
SQL> alter database clear logfile group 4;
Database altered.
SQL> alter database clear logfile group 5;
Database altered.
SQL> select group#, status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
2 UNUSED
5 UNUSED
4 UNUSED
3 CURRENT
SQL>
SQL> alter database open resetlogs;
Database altered.
No comments:
Post a Comment