Use flashback to view historical Oracle table time data

Use flashback to view historical data of the Oracle table 1. View historical data of the table select * fromtab_testASOFTIMESTAMPto_timestamp (

Use flashback to view historical data OF the Oracle table 1. View historical data OF the table select * from tab_test as of timestamp to_timestamp (

Use flashback to view historical Oracle table time data

1. View historical table time data

Select * from tab_test as of timestamp to_timestamp ('2014 10:00:00 ', 'yyyymmdd hh24: mi: ss ');

2. Use flashback table to restore the table to a certain time point in the past

Alter table tab_test enable row movement;

Flashback table tab_test to timestamp ('2017 10:00:00 ', 'yyyymmdd hh24: mi: ss ');

Alter table tab_test disable row movement;

3. View table operations in the past period to confirm the time point to be restored.

Select SQL _TEXT, LAST_ACTIVE_TIME from v $ sqlarea where LAST_ACTIVE_TIME> to_date ('2017 10:00:00 ', 'yyyymmdd hh24: mi: ss') and SQL _TEXT like' % tab_test % ';

4. Check whether flash back is enabled.

Select log_mode, flashback_on from v $ database;

Oracle 11g Flashback Data Archive (flash back Data archiving)

Oracle Flashback flash back Mechanism

Oracle Flashback database

Flashback table quick recovery of accidentally deleted data

Oracle backup recovery: Flashback flash back