Database Software

Hi All,

I am in need of some advice. First, I am running Oracle 11gR2 2 node RAC database. from last 2 week i see below error messages in my alert log everyday:

Thread 1 cannot allocate new log, sequence 15801
Checkpoint not complete

Totally i have 8 redo logs and 2 online logs and each log file size is same. I have searched in online and found some articles about this issue and it gives me some info, but not able to figure out what needs to be done for my issue.

Below are some info what i have. Please give me some advice to overcome this, and how this effects the performance.

SQL>select member from v$logfile;

MEMBER
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo05.rdo
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo06.rdo
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo03.rdo
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo04.rdo
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo07.rdo
/u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo08.rdo
/a01/oradata/ccoreqal/ccmintpt/CCMINTPTE/onlinelog/o1_mf_9_76z51dh8_.log
/a01/oradata/ccoreqal/ccmintpt/CCMINTPTE/onlinelog/o1_mf_10_76z51s0f_.log

SQL>select SEQUENCE#,BYTES/1024/1024,BLOCKSIZE,MEMBERS,STATUS,FIRST_CHANGE#, NEXT_CHANGE#,NEXT_TIME from gv$log;

SEQUENCE# BYTES/1024/1024 BLOCKSIZE MEMBERS STATUS FIRST_CHANGE# NEXT_CHANGE# NEXT_TIME
---------- --------------- ---------- ---------- -------- ------------- ------------ -------------------
15851 500 512 1 INACTIVE 1.5389E+10 1.5391E+10 10-03-2011 23:12:31
15852 500 512 1 CURRENT 1.5391E+10 2.8147E+14
14787 500 512 1 ACTIVE 1.5391E+10 1.5392E+10 10-03-2011 23:19:08
14788 500 512 1 CURRENT 1.5392E+10 2.8147E+14
7769 500 512 1 CURRENT 1.5347E+10 2.8147E+14
7768 500 512 1 INACTIVE 1.5215E+10 1.5347E+10 10-03-2011 15:15:29
11 500 512 1 INACTIVE 1.4991E+10 1.5376E+10 10-03-2011 21:00:20
12 500 512 1 CURRENT 1.5376E+10 2.8147E+14
1 500 512 1 CURRENT 1.3911E+10 2.8147E+14 09-13-2011 10:35:15
0 500 512 1 UNUSED 0 0
15851 500 512 1 INACTIVE 1.5389E+10 1.5391E+10 10-03-2011 23:12:31
15852 500 512 1 CURRENT 1.5391E+10 2.8147E+14
14787 500 512 1 ACTIVE 1.5391E+10 1.5392E+10 10-03-2011 23:19:08
14788 500 512 1 CURRENT 1.5392E+10 2.8147E+14
7769 500 512 1 CURRENT 1.5347E+10 2.8147E+14
7768 500 512 1 INACTIVE 1.5215E+10 1.5347E+10 10-03-2011 15:15:29
11 500 512 1 INACTIVE 1.4991E+10 1.5376E+10 10-03-2011 21:00:20
12 500 512 1 CURRENT 1.5376E+10 2.8147E+14
1 500 512 1 CURRENT 1.3911E+10 2.8147E+14 09-13-2011 10:35:15
0 500 512 1 UNUSED 0 0
15851 500 512 1 INACTIVE 1.5389E+10 1.5391E+10 10-03-2011 23:12:31
15852 500 512 1 CURRENT 1.5391E+10 2.8147E+14
14787 500 512 1 ACTIVE 1.5391E+10 1.5392E+10 10-03-2011 23:19:08
14788 500 512 1 CURRENT 1.5392E+10 2.8147E+14
7769 500 512 1 CURRENT 1.5347E+10 2.8147E+14
7768 500 512 1 INACTIVE 1.5215E+10 1.5347E+10 10-03-2011 15:15:29
11 500 512 1 INACTIVE 1.4991E+10 1.5376E+10 10-03-2011 21:00:20
12 500 512 1 CURRENT 1.5376E+10 2.8147E+14
1 500 512 1 CURRENT 1.3911E+10 2.8147E+14 09-13-2011 10:35:15
0 500 512 1 UNUSED 0 0

SQL>select name, value from v$parameter where name like 'fast_start%';

NAME
--------------------------------------------------------------------------------
VALUE
------------------------------------------------------------------------------------------------------------------------------------
fast_start_io_target
0

fast_start_mttr_target
0

fast_start_parallel_rollback
LOW



Some of the alert log info from node 1.

Thread 1 advanced to log sequence 15796 (LGWR switch)
Current log# 2 seq# 15796 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Mon Oct 03 16:49:47 2011
Thread 1 advanced to log sequence 15797 (LGWR switch)
Current log# 1 seq# 15797 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Mon Oct 03 17:25:27 2011
Thread 1 advanced to log sequence 15798 (LGWR switch)
Current log# 2 seq# 15798 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Mon Oct 03 17:40:24 2011
Thread 1 advanced to log sequence 15799 (LGWR switch)
Current log# 1 seq# 15799 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Mon Oct 03 17:54:16 2011
Thread 1 advanced to log sequence 15800 (LGWR switch)
Current log# 2 seq# 15800 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Mon Oct 03 17:54:37 2011
Thread 1 cannot allocate new log, sequence 15801
Checkpoint not complete
Current log# 2 seq# 15800 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Mon Oct 03 17:54:54 2011
Thread 1 advanced to log sequence 15801 (LGWR switch)
Current log# 1 seq# 15801 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Mon Oct 03 17:55:13 2011
Thread 1 cannot allocate new log, sequence 15802
Checkpoint not complete
Current log# 1 seq# 15801 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Thread 1 advanced to log sequence 15802 (LGWR switch)
Current log# 2 seq# 15802 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Mon Oct 03 17:55:40 2011
Thread 1 cannot allocate new log, sequence 15803
Checkpoint not complete
Current log# 2 seq# 15802 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Thread 1 advanced to log sequence 15803 (LGWR switch)
Current log# 1 seq# 15803 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Mon Oct 03 17:56:04 2011
Thread 1 cannot allocate new log, sequence 15804
Checkpoint not complete
Current log# 1 seq# 15803 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Thread 1 advanced to log sequence 15804 (LGWR switch)
Current log# 2 seq# 15804 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Mon Oct 03 17:56:28 2011
Thread 1 cannot allocate new log, sequence 15805
Checkpoint not complete
Current log# 2 seq# 15804 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo02.rdo
Thread 1 advanced to log sequence 15805 (LGWR switch)
Current log# 1 seq# 15805 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Mon Oct 03 17:56:55 2011
Thread 1 cannot allocate new log, sequence 15806
Checkpoint not complete
Current log# 1 seq# 15805 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo01.rdo
Thread 1 advanced to log sequence 15806 (LGWR switch)



Some of the alert log info from node 2:

Mon Oct 03 21:26:53 2011
Thread 2 advanced to log sequence 14778 (LGWR switch)
Current log# 4 seq# 14778 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo04.rdo
Mon Oct 03 21:43:02 2011
Thread 2 advanced to log sequence 14779 (LGWR switch)
Current log# 3 seq# 14779 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo03.rdo
Mon Oct 03 21:56:54 2011
Thread 2 advanced to log sequence 14780 (LGWR switch)
Current log# 4 seq# 14780 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo04.rdo
Mon Oct 03 22:00:00 2011
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Oct 03 22:00:00 2011
Starting background process VKRM
Mon Oct 03 22:00:00 2011
VKRM started with pid=631, OS id=13692
Mon Oct 03 22:09:14 2011
Thread 2 advanced to log sequence 14781 (LGWR switch)
Current log# 3 seq# 14781 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo03.rdo
Mon Oct 03 22:19:26 2011
Thread 2 advanced to log sequence 14782 (LGWR switch)
Current log# 4 seq# 14782 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo04.rdo
Mon Oct 03 22:29:04 2011
Thread 2 advanced to log sequence 14783 (LGWR switch)
Current log# 3 seq# 14783 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo03.rdo
Mon Oct 03 22:39:53 2011
Thread 2 advanced to log sequence 14784 (LGWR switch)
Current log# 4 seq# 14784 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo04.rdo
Mon Oct 03 22:45:52 2011
Trace dumping is performing id=[cdmp_20111003224551]
Mon Oct 03 22:45:53 2011
Global Enqueue Services Deadlock detected. More info in file
/u01/app/ccoreqal/oracle/diag/rdbms/ccmintpte/ccmintpt2/trace/ccmintpt2_ora_24742.trc.
Mon Oct 03 22:46:01 2011
Global Enqueue Services Deadlock detected. More info in file
/u01/app/ccoreqal/oracle/diag/rdbms/ccmintpte/ccmintpt2/trace/ccmintpt2_lmd0_17603.trc.
Global Enqueue Services Deadlock detected. More info in file
/u01/app/ccoreqal/oracle/diag/rdbms/ccmintpte/ccmintpt2/trace/ccmintpt2_lmd0_17603.trc.
Mon Oct 03 22:46:12 2011
Trace dumping is performing id=[cdmp_20111003224612]
Mon Oct 03 22:49:05 2011
Thread 2 advanced to log sequence 14785 (LGWR switch)
Current log# 3 seq# 14785 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo03.rdo
Mon Oct 03 23:04:57 2011
Thread 2 advanced to log sequence 14786 (LGWR switch)
Current log# 4 seq# 14786 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo04.rdo
Mon Oct 03 23:11:55 2011
Thread 2 advanced to log sequence 14787 (LGWR switch)
Current log# 3 seq# 14787 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo03.rdo
Mon Oct 03 23:19:09 2011
Thread 2 advanced to log sequence 14788 (LGWR switch)
Current log# 4 seq# 14788 mem# 0: /u04/oradata/ccoreqal/ccmintpt/ccmintpte/redo04.rdo



Please give me for any information.

Thanks in advance.