oracle 处理找被删掉且提交了事务的数据

今天很蠢，正式环境的数据删除前忘记备份数据，尴尬至极......

终于找到一个半个小时内可以查到删掉的数据（即使已提交）
不多说，上sql

select * from ( select * from T_PYFA_GRKCSQ where grpyjhsq_id in ('S2109071002420212021_090_01_071000090031433632912656744448')) as of timestamp to_timestamp('2021-09-05 13:11:40','yyyy-mm-dd hh24:mi:ss')

select * from T_XSGL_JLXL as of timestamp to_timestamp('2022-08-17 11:10:40', 'yyyy-mm-dd hh24:mi:ss') where XS_ID in ('T22590101018')