UNKNOWN 1103738 13-MAY-16 delete from "JY"."T1" where "T_ID" = '2' and "T_NAME" = 'wj' and "T_SALARY" = '8000' and ROWID = 'AAANc6AAEAAAAGFAAA'; insert into "JY"."T1"("T_ID","T_NAME","T_SALARY") values ('2','wj','8000');
JY 1103789 13-MAY-16 alter table t1 modify t_salary number(10);
从查询结果来看删除操作对应的sql_redo为:delete from "JY"."T1" where "T_ID" = '2' and "T_NAME" = 'wj' and "T_SALARY" = '8000' and ROWID = 'AAANc6AAEAAAAGFAAA',对应的sql_undo为:insert into "JY"."T1"("T_ID","T_NAME","T_SALARY") values ('2','wj','8000');为了恢复删除的t_id=2的记录,只需要执行sql_undo为insert into "JY"."T1"("T_ID","T_NAME","T_SALARY") values ('2','wj','8000')的语句就能恢复。