本文主要是介绍ORA-25319: Queue table repartitioning aborted，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
--ORA-25319: Queue table repartitioning aborted发生背景：
监控日志时无限刷出
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127448):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Fri Dec 30 20:16:04 2016
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127449):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127450):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127451):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127452):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127453):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127454):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127455):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127456):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127457):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_7202.trc (incident=127458):
ORA-25319: Queue table repartitioning aborted
error 25319 happened during Queue table repartitioning
DDE: Problem Key 'ORA 25319' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 25319 happened during Queue table repartitioning
error 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 - Production
With 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 43001059062 43001059063 43001059064 43001059065 42999028056 43001059067 43001059068 43001059069 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; --尝试恢复数据文件5
ORA-00283: recovery session canceled due to errors
ORA-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 - Production
With 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
这篇关于ORA-25319: Queue table repartitioning aborted的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
