ORA-25319: Queue table repartitioning aborted

--ORA-25319: Queue table repartitioning aborted

发生背景：

监控日志时无限刷出ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127448):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningFri Dec 30 20:16:04 2016Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127449):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127450):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127451):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127452):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127453):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127454):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127455):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127456):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127457):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc  (incident=127458):ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningDDE: Problem Key 'ORA 25319' was completely flood controlled (0x6)Further messages for this problem key will be suppressed for up to 10 minuteserror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioningerror 25319 happened during Queue table repartitioning

解决方法及过程：

[oracle@ocm1 ~]$ sqlplus sys/oracle@prod1 as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 30 20:18:25 2016Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSYS@prod1> select file#,to_char(checkpoint_change#,'999999999999') from v$datafile;     FILE# TO_CHAR(CHECK---------- ------------- 1    4300105906 2    4300105906 3    4300105906 4    4300105906 5    4299902805 6    4300105906 7    4300105906 8    4300105906 9    430010590610    430010590611    430010590612    430010590613    430010590614    430010590615    430010590616    430010590617    430010590618    430010590618 rows selected.SYS@prod1> select file#,online_status,to_char(change#,'999999999999') from v$recover_file;     FILE# ONLINE_ TO_CHAR(CHANG---------- ------- ------------- 5 OFFLINE       0SYS@prod1> recover datafile 5;  --尝试恢复数据文件5ORA-00283: recovery session canceled due to errorsORA-00264: no recovery requiredSYS@prod1> ALTER TABLESPACE EXAMPLE ONLINE；  [oracle@ocm1 ~]$ sqlplus sys/oracle@prod1 as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 30 20:19:48 2016Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSYS@prod1> select file#,online_status,to_char(change#,'999999999999') from v$recover_file;no rows selected

解决完成日志不再报错。


参考资料：http://www.xifenfei.com/2011/12/%E6%A8%A1%E6%8B%9F%E8%B7%A8resetlogs%E6%81%A2%E5%A4%8D.html