Logswitches on RAC-instance which is closed.
Hi,
Before raising an SR I want to know if we are encountering the following Bug 3063996 Frequent log switches can occur in RAC if a thread closes. I came on this one after a discussion in the Toad-forum about the logswitchfrequency map.
Case: we have a Linux RAC-cluster and a database with only one instance active.
Information of v$thread:
10:55:19 > nl@XXXP > select * from v$thread;
1 CLOSED PUBLIC 3 XXXP1
08-MEI-2009 14:39:11 3 18399 9,2585E+12 15-DEC
-2009 10:54:10 1 08-MEI-2009 09:32:49 0
3 110139 504764 08-MEI-2009 14:43:23
2 OPEN PUBLIC 3 XXXP2
07-OKT-2009 06:44:00 5 20231 9,2585E+12 15-DEC
-2009 10:43:59 480173 08-MEI-2009 09:41:34 0
20231 64075 9,2585E+12 15-DEC-2009 10:55:22
V$loghist for the last 2 hours show:
11:40:18 > nl@XXXP > select * from v$loghist where first_time>sysdate-1/12;