Hi all,
This is an Oracle 10.2.0.4 for Windows 32 bits Standard Edition
I'm trying to resize the online redologs, but it is very hard to get them inactive.
Every time I check them, I get:
GROUP# STATUS
---------- ----------------
1 ACTIVE
2 CURRENT
3 UNUSED
4 ACTIVE
As per my understanding active means they are needed in case of a crash recovery, but isn't it the problem that archiver takes too much time and therefore the group can't be released ?
If so, how can I speed up the archiver process?
I have already tried with "alter system switch logfile", but it just changes the current group and leaves the rest as "active".
Thanks in advance.