logminer来恢复在表DDL之前被删除的数据(6)

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')的语句就能恢复。

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/a171bb74c81aa36378b175944a5b2d4d.html