Problem
:-ORA-00392 log 5 of thread 1 is being
cleared, operation not allowed
SQL>
alter database open resetlogs;
alter
database open resetlogs
*
ERROR
at line 1:
ORA-00392:
log 5 of thread 1 is being cleared, operation not allowed
ORA-00312:
online log 5 thread 1:
'/ORACLE/ORA_27_Datafiles/redotempfiles/log05a.dbf'
ORA-00312:
online log 5 thread 1:
'/ORACLE/ORA_27_Datafiles/redotempfiles/log05b.dbf'
Solution:-
SQL>
select group#, status from v$log;
GROUP# STATUS
----------
----------------
3 CLEARING
5 CLEARING_CURRENT
4 CLEARING
SQL>
alter database clear unarchived logfile group 3;
Database
altered.
SQL>
alter database clear unarchived logfile group 5;
Database
altered.
SQL>
alter database clear unarchived logfile group 4;
Database
altered.
SQL>
select group#, status from v$log;
GROUP# STATUS
----------
----------------
3 UNUSED
5 CURRENT
4 UNUSED
SQL>
alter database open resetlogs;
Database
altered.
SQL>
select name ,open_mode from v$database;
NAME
OPEN_MODE
---------
--------------------
PROD
READ WRITE
