恢复表的历史数据

oracle数据恢复

select * FROM table_name as of TIMESTAMP to_timestamp('2012-09-17 17:00:22','yyyy-mm-dd hh24:mi:ss')

查出某时间点数据，然后插入到表中恢复数据







INSERT INTO mpm_pro select * FROM table_name  as of TIMESTAMP to_timestamp('2012-09-26 17:00:22','yyyy-mm-dd hh24:mi:ss') where

每隔5分钟，系统产生一次系统时间标记与scn的匹配并存入

sys.smon_scn_time表。