故障报告

1. 问题（故障）描述

模拟500万insert：
insert into test select * from tb02 where rownum<5000001;
排查zcbus_real日志发现，分析多出894条记录：

zcbus_real进程报错日志：

error at file[oralib.c] line[1372], ZCBUS-1000: OCI ret -1 at file oralib.c:1371, 192.168.0.115:1521/prod.
ORA-00310: archived log contains sequence 1512; sequence 1510 required
ORA-00334: archived log: '+DATADG/PROD/ONLINELOG/group_2.263.1082456823'
OCI Error - OCI_ERROR
error at file[logmnr/process.c] line[563], ZCBUS-1000: OCI ret -1 at file oralib.c:1371, 192.168.0.115:1521/prod.
ORA-00310: archived log contains sequence 1512; sequence 1510 required
ORA-00334: archived log: '+DATADG/PROD/ONLINELOG/group_2.263.1082456823'
OCI Error - OCI_ERROR
[ERR] LOG THD[3]: ZCBUS-1000: OCI ret -1 at file oralib.c:1371, 192.168.0.115:1521/prod.
ORA-00310: archived log contains sequence 1512; sequence 1510 required
ORA-00334: archived log: '+DATADG/PROD/ONLINELOG/group_2.263.1082456823'
OCI Error - OCI_ERROR
[LV1] SQL-> SELECT FIRST_CHANGE#, NEXT_CHANGE#, THREAD#, SEQUENCE#, NAME FROM(SELECT FIRST_CHANGE#, NEXT_CHANGE#, THREAD#, SEQUENCE#, MEMBER AS NAME from v$log v, v$logfile l where v.GROUP# = l.GROUP# and v.status = 'CURRENT' UNION SELECT FIRST_CHANGE#, NEXT_CHANGE#, THREAD#, SEQUENCE#, NAME FROM V$ARCHIVED_LOG WHERE NAME IS NOT NULL AND STANDBY_DEST = 'NO' AND STATUS = 'A') where THREAD#=:1 and SEQUENCE#=:2

2. 问题（故障）原因

redo日志size小或者日志组比较少，操作过多导致日志切换频繁，logmnr分析跟不上，redo分析不过来，重复分析归档，导致数据重复分析。

3. 解决

建议在线增加多组redo日志。

4. 参考

rac+asm添加增加redo日志组命令：

alter database add logfile thread 1 group 5 size 200M;
alter database add logfile thread 1 group 6 size 200M;
alter database add logfile thread 2 group 7 size 200M;
alter database add logfile thread 2 group 8 size 200M;