oracle cannot allocate new log,oracle 11g 日志问题Thread 1 cannot allocate new log,

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';

请大家帮忙看看!!!!

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值