ORA-55507: Encountered mining error during Flashback Transaction Backout. functi
SQL> declare
2 xids sys.xid_array;
3 begin
4 xids := sys.xid_array('0A000B00A5020000');
5 dbms_flashback.transaction_backout(1,xids,options=>dbms_flashback.cascade);
6 end;
7 /
declare
*
ERROR at line 1:
ORA-55507: Encountered mining error during Flashback Transaction Backout.
function:krvxglsr
ORA-01291: missing logfile
ORA-06512: at "SYS.DBMS_FLASHBACK", line 37
ORA-06512: at "SYS.DBMS_FLASHBACK", line 70
ORA-06512: at line 5
遇到此报错检查数据库是否生成新的归档日志：
SQL> alter system switch logfile;
手动生成归档日志文件即可
SQL> declare
2 xids sys.xid_array;
3 begin
4 xids := sys.xid_array('0A000B00A5020000');
5 dbms_flashback.transaction_backout(1,xids,options=>dbms_flashback.cascade);
6 end;
7 /
PL/SQL procedure successfully completed.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23825935/viewspace-2702584/ ，如需转载，请注明出处，否则将追究法律责任。
