数据库有四组日志,每组1G大小,可能业务原因,有时切换快,有时切换慢,使用完日志组1再次使用日志组1基本都在五六个小时之后,但alert log里还是提示Thread 1 cannot allocate new log, sequence 68446
Private strand flush not complete,不可能几个小时了,log还没写进磁盘,大神帮忙分析下原因
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 68451 1069547520 2 YES INACTIVE 1450104691607 2017/3/28 2
2 1 68452 1069547520 2 YES INACTIVE 1450104695055 2017/3/28 1
3 1 68453 1069547520 2 NO CURRENT 1450104695060 2017/3/28 1
4 1 68450 1069547520 2 YES INACTIVE 1450104691606 2017/3/28 2
SQL> select * from dba_data_files order by file_name;
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS
-------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- ----------- -------------
/dev/m8ndata/rm8ndata000 5 XINEM8000 4183818240 510720 AVAILABLE 5 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata001 6 XINEM8000 4183818240 510720 AVAILABLE 6 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata002 7 XINEM8000 4183818240 510720 AVAILABLE 7 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata003 8 XINEM8000 4183818240 510720 AVAILABLE 8 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata004 9 XINEM8000 4183818240 510720 AVAILABLE 9 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata005 10 XINEM8000 4183818240 510720 AVAILABLE 10 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata006 11 XINEM8000 4183818240 510720 AVAILABLE 11 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata007 12 XINEM8000 4183818240 510720 AVAILABLE 12 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata008 13 XINEM8000 4183818240 510720 AVAILABLE 13 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata009 14 XINEM8000 4183818240 510720 AVAILABLE 14 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata010 15 XINEM8000 4183818240 510720 AVAILABLE 15 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata011 16 XINEM8000 4183818240 510720 AVAILABLE 16 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata012 17 XINEM8000 4183818240 510720 AVAILABLE 17 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata013 18 XINEM8000 4183818240 510720 AVAILABLE 18 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata014 19 XINEM8000 4183818240 510720 AVAILABLE 19 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata015 20 XINEM8000 4183818240 510720 AVAILABLE 20 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata016 21 XINEM8000 4183818240 510720 AVAILABLE 21 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata017 22 XINEM8000 4183818240 510720 AVAILABLE 22 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata018 23 XINEM8000 4183818240 510720 AVAILABLE 23 NO 0 0 0 4183752704 510712 ONLINE
/dev/m8ndata/rm8ndata019 24 XINEM8000 4183818240 510720 AVAILABLE 24 NO 0 0 0 4183752704 510712 ONLINE
日志显示
Mon Mar 27 10:24:06 EAT 2017
Thread 1 cannot allocate new log, sequence 68446
Private strand flush not complete
Current log# 3 seq# 68445 mem# 0: /dev/vgimage/rredo2_3
Current log# 3 seq# 68445 mem# 1: /dev/updatavg/rredo1_3
Mon Mar 27 10:24:07 EAT 2017
Thread 1 advanced to log sequence 68446 (LGWR switch)
Current log# 4 seq# 68446 mem# 0: /dev/vgimage/rredo2_4
Current log# 4 seq# 68446 mem# 1: /dev/updatavg/rredo1_4
Mon Mar 27 10:24:14 EAT 2017
ALTER SYSTEM ARCHIVE LOG
Mon Mar 27 10:24:14 EAT 2017
Thread 1 cannot allocate new log, sequence 68447
Private strand flush not complete
Current log# 4 seq# 68446 mem# 0: /dev/vgimage/rredo2_4
Current log# 4 seq# 68446 mem# 1: /dev/updatavg/rredo1_4
Mon Mar 27 10:24:16 EAT 2017
Thread 1 advanced to log sequence 68447 (LGWR switch)
Current log# 1 seq# 68447 mem# 0: /dev/vgimage/rredo2_1
Current log# 1 seq# 68447 mem# 1: /dev/updatavg/rredo1_1
日志组.jpg
(33.36 KB, 下载次数: 16)
2017-3-28 12:03 上传
日志组
日志组切换时间.jpg
(148.87 KB, 下载次数: 11)
2017-3-28 12:04 上传