Redo log help!

Quote:

---

SQL> select group#, thread#, sequence#, status, archived from v$log;

GROUP# THREAD# SEQUENCE# STATUS ARC
---------- ---------- ---------- ---------------- ---
1 1 61 INACTIVE YES
2 1 62 INACTIVE YES
3 1 63 INACTIVE YES
4 1 64 CURRENT NO
5 2 36 INACTIVE YES
6 2 37 CURRENT NO

6 rows selected.

---

Now I try to drop group 5 and 6 but giving me error below..

Quote:

---

SQL> alter database drop logfile group 5;
alter database drop logfile group 5
*
ERROR at line 1:
ORA-01567: dropping log 5 would leave less than 2 log files in thread 2
ORA-00312: online log 5 thread 2: '/parh/redo05.log'

---

Even I switch the logfiles

Quote:

---

SQL> alter system switch logfile;

System altered.

---

I think it has to do with the THREAD#.

Any idea how can I drop it?

Thanks

is this RAC - you have two threads, each thread must have more than one group

Yes davey23uk, it is RAC. Sorry about not mentioning it. I was multiplexing the logs.
I did manager to multiplex 1 through 4, but stuck in 5 and 6. Any suggestion would be greatly appreciate it.

As you only have two groups for thread 2, you'd need to add another one before you can drop group 5.

Thank you so much!

I added LOGFILE THREAD 2 and alll worked fine.