While importing a DB in oracle, I found the following warnings in the log:
Thread 1 cannot allocate new log, sequence 1299 Checkpoint not complete Current log# 3 seq# 1298 mem# 0: /oradata/TESTDB/redo03.log Thread 1 cannot allocate new log, sequence 1300 Checkpoint not complete Current log# 6 seq# 1299 mem# 0: /oradata/TESTDB/redo06.log
At the same time, iostat reported low values for disk utilization
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util dm-12 0,00 0,00 7,40 531,40 2,39 42,44 170,40 0,35 0,66 0,47 25,52 dm-13 0,00 0,00 0,00 23,00 0,00 8,23 733,05 0,42 18,14 0,42 0,96 avg-cpu: %user %nice %system %iowait %steal %idle 8,28 0,00 9,45 6,86 0,00 75,41 Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util dm-12 0,00 0,00 16,80 999,80 5,55 94,42 201,40 5,89 5,79 0,53 53,50 dm-13 0,00 0,00 0,00 52,00 0,00 16,54 651,34 1,01 19,48 1,05 5,48 avg-cpu: %user %nice %system %iowait %steal %idle 6,19 0,00 1,83 1,73 0,00 90,25 Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util dm-12 0,00 0,00 5,40 840,40 1,95 24,87 64,93 0,29 0,35 0,29 24,94 dm-13 0,00 0,00 0,00 49,00 0,00 16,48 688,74 0,79 15,76 0,38 1,86
A Checkpoint error means that oracle stops processing new entries because the redo logs were not committed to the database file.
The solution was just adding more redo-log files via sqlplus
ALTER DATABASE ADD LOGFILE ( '/oradata/TESTDB/redo10.log', '/oradata/TESTDB/redo11.log', '/oradata/TESTDB/redo12.log', '/oradata/TESTDB/redo13.log', '/oradata/TESTDB/redo14.log' ) size 50M ;