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.