Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Redolog is never INACTIVE

happy10319Nov 17 2009 — edited Nov 17 2009
Hi,
in 10g R2 on Win 2003, I have created new log groups and want to DROP the ancient , then I wait that it beocmes INACTIVE.


According to documentation :
•You can drop a redo log group only if it is inactive. If you need to drop the current group, first force a log switch to occur.

SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG;

   GROUP# ARC STATUS
--------- --- ----------------
        1 YES ACTIVE
        2 NO  CURRENT
        3 YES INACTIVE
        4 YES INACTIVE
I try ALTER SYSTEM SWITCH LOGFILE; every now and then , but it is always INACTIVE.

Thank you.
This post has been answered by Robert Geier on Nov 17 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2009
Added on Nov 17 2009
4 comments
481 views