[size=large]1.闪回到某个时间点前数据查询:
select * from yongqidizhi as of timestamp to_timestamp('2014-11-10 11:39:00','yyyy-mm-dd hh24:mi:ss');
--'2014-11-10 11:39:00' 这个时间是删除数据前的时间点
--检查核对查询出来的数据是否是丢失前的数据
2.将数据恢复到一个临时表,再次核对恢复的数据是否正确
insert into yongqidizhi_tmp (select * from yongqidizhi as of timestamp to_timestamp('2014-11-10 11:39:00','yyyy-mm-dd hh24:mi:ss'));
3.将临时表数据插入正式表
insert into yongqidizhi (select * from yongqidizhi_tmp);[/size]
select * from yongqidizhi as of timestamp to_timestamp('2014-11-10 11:39:00','yyyy-mm-dd hh24:mi:ss');
--'2014-11-10 11:39:00' 这个时间是删除数据前的时间点
--检查核对查询出来的数据是否是丢失前的数据
2.将数据恢复到一个临时表,再次核对恢复的数据是否正确
insert into yongqidizhi_tmp (select * from yongqidizhi as of timestamp to_timestamp('2014-11-10 11:39:00','yyyy-mm-dd hh24:mi:ss'));
3.将临时表数据插入正式表
insert into yongqidizhi (select * from yongqidizhi_tmp);[/size]