Tail -1000f alert_MES1.log;
在数据导入时,发现大量Checkpoint not complete 错误!Checkpoint not complete
Current log# 1 seq# 593 mem# 0: +DATADG/mesprod/onlinelog/group_1.876.862322921
Thread 1 advanced to log sequence 594 (LGWR switch)
Current log# 2 seq# 594 mem# 0: +DATADG/mesprod/onlinelog/group_2.877.862322921
Archived Log entry 1414 added for thread 1 sequence 593 ID 0x40399f64 dest 1:
Archived Log entry 1415 added for thread 1 sequence 593 ID 0x40399f64 dest 2:
Thread 1 cannot allocate new log, sequence 595
Checkpoint not complete
Current log# 2 seq# 594 mem# 0: +DATADG/mesprod/onlinelog/group_2.877.862322921
Thread 1 advanced to log sequence 595 (LGWR switch)
Current log# 1 seq# 595 mem# 0: +DATADG/mesprod/onlinelog/group_1.876.862322921
Wed Nov 05 15:29:56 2014
Archived Log entry 1417 added for thread 1 sequence 594 ID 0x40399f64 dest 1:
Archived Log entry 1418 added for thread 1 sequence 594 ID 0x40399f64 dest 2:
Thread 1 cannot allocate new log, sequence 596
进过检查每个节点只有两个日志文件,每个日志文件只有50M,实在太小了。
SQL> select group#,thread#,bytes/1024/1024 from V$log;
GROUP# THREAD# BYTES/1024/1024
---------- ---------- ---------------
1 1 50
2 1 50
3 2 50
4 2 50
节点1
alter database add logfile group 5 ('+DATADG/MESPROD/onlinelog/group5_1.log') size 1024m;
alter database add logfile group 6 ('+DATADG/MESPROD/onlinelog/group6_1.log') size 1024m;
alter database add logfile group 7 ('+DATADG/MESPROD/onlinelog/group7_1.log') size 1024m;
alter database add logfile group 8 ('+DATADG/MESPROD/onlinelog/group8_1.log') size 1024m;
节点2
alter database add logfile group 9 ('+DATADG/MESPROD/onlinelog/group9_1.log') size 1024m;
alter database add logfile group 10 ('+DATADG/MESPROD/onlinelog/group10_1.log') size 1024m;
alter database add logfile group 11 ('+DATADG/MESPROD/onlinelog/group11_7.log') size 1024m;
alter database add logfile group 12 ('+DATADG/MESPROD/onlinelog/group12_1.log') size 1024m;
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
Database altered.
SQL> ALTER DATABASE DROP LOGFILE GROUP 2;
Database altered.
SQL> ALTER DATABASE DROP LOGFILE GROUP 3
2 ;
Database altered.
SQL> ALTER DATABASE DROP LOGFILE GROUP 4;
Database altered.
完全正常