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.
