IMP Checkpoint not complete

IMP在导入到一张很大表的时候过了很久卡住了，


TY测试服务器刚才IMP卡在了REPORT_SALE_FULL，昨天看就是在这里，首先切了下日志。后来又卡在了REPORT_SALE_FULL_0411。看alter 有大量Checkpoint not complete 错误，在网上找了下， 增加了5个日志组，每个200m，现在正常了。


SQL> alter system switch logfile;


SQL> ALTER SYSTEM CHECKPOINT;

SQL> alter database add logfile 'd:\\redo04.log' size 200m;

ed Mar 14 02:47:51 2012
Thread 1 advanced to log sequence 3959
Current log# 2 seq# 3959 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO02.LOG
Wed Mar 14 08:59:41 2012
Thread 1 advanced to log sequence 3960
Current log# 1 seq# 3960 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO01.LOG
Wed Mar 14 09:03:23 2012
Thread 1 advanced to log sequence 3961
Current log# 3 seq# 3961 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO03.LOG
Thread 1 cannot allocate new log, sequence 3962
Checkpoint not complete
Current log# 3 seq# 3961 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO03.LOG
Thread 1 advanced to log sequence 3962
Current log# 2 seq# 3962 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO02.LOG
Wed Mar 14 09:03:43 2012
Thread 1 cannot allocate new log, sequence 3963
Checkpoint not complete
Current log# 2 seq# 3962 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO02.LOG
Thread 1 advanced to log sequence 3963
Current log# 1 seq# 3963 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO01.LOG
Wed Mar 14 09:03:56 2012
Thread 1 advanced to log sequence 3964
Current log# 3 seq# 3964 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO03.LOG
Thread 1 cannot allocate new log, sequence 3965
Checkpoint not complete
Current log# 3 seq# 3964 mem# 0: E:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\REDO03.LOG




SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 4261 52428800 1 NO ACTIVE
15742203 14-3月 -12

2 1 4259 52428800 1 NO ACTIVE
15738786 14-3月 -12

3 1 4262 52428800 1 NO CURRENT
15742842 14-3月 -12


GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
4 1 4260 209715200 1 NO ACTIVE
15739434 14-3月 -12

5 1 4255 209715200 1 NO INACTIVE
15701197 14-3月 -12

6 1 4256 209715200 1 NO INACTIVE
15719165 14-3月 -12


GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
7 1 4257 209715200 1 NO ACTIVE
15733153 14-3月 -12

8 1 4258 209715200 1 NO ACTIVE
15735972 14-3月 -12


已选择8行。