-
Redo log help!
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..
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
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.
Assistance is Futile...
-
Thank you so much!
I added LOGFILE THREAD 2 and alll worked fine.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|