用户名:   自动登录 找回密码
密   码:    * 注册




发表新帖 回复这个主题  [ 1 篇帖子 ] 
作者 内容
 文章标题 : IMP卡住了解决
帖子发表于 : 2012-04-20 21:24 
离线
头像

注册: 2011-05-01 9:15
帖子: 120
IMP在导入到一张很大表的时候过了很久卡住了,


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


代码:
SQL> alter system switch logfile;


SQL> ALTER SYSTEM CHECKPOINT;

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



alert:
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行。


页首
 用户资料  
 
显示帖子 :  排序  
发表新帖 回复这个主题  [ 1 篇帖子 ] 


在线用户

注册用户: 没有注册用户


查找:
前往 :  
cron
Powered by OraSql © 2011, 2012, oracle_awen