OEM12C web页面无法访问进入实例

客户OEM12c 12.1.0.5

现象:EM web界面可以正常登陆显示,在访问某一实例点击进去需要输入用户名密码登陆时候无反应,过一会提示超时或者页面丢失

处理:

当出现这种情况的时候 后台资源库 EMREP 的alter.log日志 大量出现
Thread 1 cannot allocate new log, sequence 55963
Checkpoint not complete
Private strand flush not complete

redo日志空间不够,循环写入产生竞争,如当前current 是group1 写满,正常需要切换到 goup2继续写,但是group2 还没有归档完毕。这时就出现上面的错误警告
(截图了部分)

Thread 1 advanced to log sequence 55960 (LGWR switch)
  Current log# 1 seq# 55960 mem# 0: /d01/app/oracle/oradata/EMREP/redo01.log
Thread 1 advanced to log sequence 55961 (LGWR switch)
  Current log# 2 seq# 55961 mem# 0: /d01/app/oracle/oradata/EMREP/redo02.log
Thread 1 cannot allocate new log, sequence 55962
Checkpoint not complete
  Current log# 2 seq# 55961 mem# 0: /d01/app/oracle/oradata/EMREP/redo02.log
Mon Jul 09 18:00:29 2018
Thread 1 advanced to log sequence 55962 (LGWR switch)
  Current log# 3 seq# 55962 mem# 0: /d01/app/oracle/oradata/EMREP/redo03.log
Thread 1 cannot allocate new log, sequence 55963
Checkpoint not complete
  Current log# 3 seq# 55962 mem# 0: /d01/app/oracle/oradata/EMREP/redo03.log
Mon Jul 09 18:00:46 2018
Thread 1 advanced to log sequence 55963 (LGWR switch)
  Current log# 1 seq# 55963 mem# 0: /d01/app/oracle/oradata/EMREP/redo01.log
Thread 1 cannot allocate new log, sequence 55964
Checkpoint not complete



Thread 1 advanced to log sequence 55970 (LGWR switch)
  Current log# 2 seq# 55970 mem# 0: /d01/app/oracle/oradata/EMREP/redo02.log
Mon Jul 09 21:49:33 2018
Thread 1 cannot allocate new log, sequence 55971
Private strand flush not complete

处理办法在线增加redo
alter database add logfile group 4 ‘/u01/app/oracle/oradata/EMREP/redo04.log’ size 300m;
alter database add logfile group 5 ‘/u01/app/oracle/oradata/EMREP/redo05.log’ size 300m;
alter database add logfile group 6 ‘/u01/app/oracle/oradata/EMREP/redo06.log’ size 300m;

然后
alter system switch logfile; –切换 current 在 group 4,5,6中一个
alter database checkpoint; —-日志刷盘,让group 1,2,3状态都是 INACTIVE

删除日志组
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;

OS上删除日志文件
rm /u01/app/oracle/oradata/EMREP/redo01.log’
rm /u01/app/oracle/oradata/EMREP/redo02.log’
rm /u01/app/oracle/oradata/EMREP/redo03.log’

发布了41 篇原创文章 · 获赞 2 · 访问量 2万+
展开阅读全文

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: 编程工作室 设计师: CSDN官方博客

分享到微信朋友圈

×

扫一扫,手机浏览