系统集成OracleOracle11gr2

oracle 11G 日志Thread 1 cannot allocate new log, sequence 13503 Checkpoint not complete?

tail -100f alert*.logArchived Log entry 22067 added for thread 1 sequence 13501 ID 0xffffffffffe006b9 dest 1:Wed Dec 27 07:46:14 2017Thread 1 cannot allocate new log, sequence 13503Checkpoint not complete Current log# 2 seq# 13502 mem# 0: +DATA/erpd...显示全部

tail -100f alert*.log
Archived Log entry 22067 added for thread 1 sequence 13501 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:46:14 2017
Thread 1 cannot allocate new log, sequence 13503
Checkpoint not complete
Current log# 2 seq# 13502 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Thread 1 advanced to log sequence 13503 (LGWR switch)
Current log# 5 seq# 13503 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Wed Dec 27 07:46:18 2017
Archived Log entry 22068 added for thread 1 sequence 13502 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:47:17 2017
Thread 1 cannot allocate new log, sequence 13504
Checkpoint not complete
Current log# 5 seq# 13503 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Thread 1 advanced to log sequence 13504 (LGWR switch)
Current log# 1 seq# 13504 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Wed Dec 27 07:47:21 2017
Archived Log entry 22070 added for thread 1 sequence 13503 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:48:20 2017
Thread 1 cannot allocate new log, sequence 13505
Checkpoint not complete
Current log# 1 seq# 13504 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Thread 1 advanced to log sequence 13505 (LGWR switch)
Current log# 2 seq# 13505 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Wed Dec 27 07:48:24 2017
Archived Log entry 22071 added for thread 1 sequence 13504 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:49:23 2017
Thread 1 cannot allocate new log, sequence 13506
Checkpoint not complete
Current log# 2 seq# 13505 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Thread 1 advanced to log sequence 13506 (LGWR switch)
Current log# 5 seq# 13506 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Wed Dec 27 07:49:27 2017
Archived Log entry 22072 added for thread 1 sequence 13505 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:50:26 2017
Thread 1 cannot allocate new log, sequence 13507
Checkpoint not complete
Current log# 5 seq# 13506 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Thread 1 advanced to log sequence 13507 (LGWR switch)
Current log# 1 seq# 13507 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Wed Dec 27 07:50:30 2017
Archived Log entry 22074 added for thread 1 sequence 13506 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:51:29 2017
Thread 1 cannot allocate new log, sequence 13508
Checkpoint not complete
Current log# 1 seq# 13507 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Thread 1 advanced to log sequence 13508 (LGWR switch)
Current log# 2 seq# 13508 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Wed Dec 27 07:51:33 2017
Archived Log entry 22075 added for thread 1 sequence 13507 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:52:29 2017
Thread 1 cannot allocate new log, sequence 13509
Checkpoint not complete
Current log# 2 seq# 13508 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Thread 1 advanced to log sequence 13509 (LGWR switch)
Current log# 5 seq# 13509 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Wed Dec 27 07:52:33 2017
Archived Log entry 22076 added for thread 1 sequence 13508 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:53:32 2017
Thread 1 cannot allocate new log, sequence 13510
Checkpoint not complete
Current log# 5 seq# 13509 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Thread 1 advanced to log sequence 13510 (LGWR switch)
Current log# 1 seq# 13510 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Wed Dec 27 07:53:36 2017
Archived Log entry 22078 added for thread 1 sequence 13509 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:54:35 2017
Thread 1 cannot allocate new log, sequence 13511
Checkpoint not complete
Current log# 1 seq# 13510 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Thread 1 advanced to log sequence 13511 (LGWR switch)
Current log# 2 seq# 13511 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Wed Dec 27 07:54:39 2017
Archived Log entry 22079 added for thread 1 sequence 13510 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:55:38 2017
Thread 1 cannot allocate new log, sequence 13512
Checkpoint not complete
Current log# 2 seq# 13511 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Thread 1 advanced to log sequence 13512 (LGWR switch)
Current log# 5 seq# 13512 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Wed Dec 27 07:55:42 2017
Archived Log entry 22080 added for thread 1 sequence 13511 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:56:38 2017
Thread 1 cannot allocate new log, sequence 13513
Checkpoint not complete
Current log# 5 seq# 13512 mem# 0: +DATA/erpdb/onlinelog/group_5.263.848792895
Thread 1 advanced to log sequence 13513 (LGWR switch)
Current log# 1 seq# 13513 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Wed Dec 27 07:56:42 2017
Archived Log entry 22082 added for thread 1 sequence 13512 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 07:59:59 2017
Thread 1 cannot allocate new log, sequence 13514
Checkpoint not complete
Current log# 1 seq# 13513 mem# 0: +DATA/erpdb/onlinelog/group_1.261.848792895
Thread 1 advanced to log sequence 13514 (LGWR switch)
Current log# 2 seq# 13514 mem# 0: +DATA/erpdb/onlinelog/group_2.262.848792895
Wed Dec 27 08:00:03 2017
Archived Log entry 22083 added for thread 1 sequence 13513 ID 0xffffffffffe006b9 dest 1:
Wed Dec 27 08:33:03 2017
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_1_20171227072452.ERPDB' SCOPE=MEMORY SID='erpdb1';
ALTER SYSTEM SET service_names='erpdb' SCOPE=MEMORY SID='erpdb1';

收起
参与7

查看其它 2 个回答793135970a的回答

793135970a793135970a  信息安全师 , qqq

1222222.png

1222222.png

日志在线

系统集成 · 2017-12-27
浏览4821

回答者

793135970a
信息安全师qqq
擅长领域: 服务器UnixAIX

793135970a 最近回答过的问题

回答状态

  • 发布时间:2017-12-27
  • 关注会员:3 人
  • 回答浏览:4821
  • X社区推广