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
2 comments:
yeah I am agree with your points you discussed. I know the importance of oracle that is the reason I am getting Oracle online training
Awesome, save my a lot of time
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.