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.