Use Flashback to view Oracle Table historical moment data

Use Flashback to view Oracle Table historical moment data

1. View the table history moment data

SELECT * from Tab_test as of TIMESTAMP to_timestamp (' 20140917 10:00:00 ', ' yyyymmdd hh24:mi:ss ');

2. Use Flashback table to restore the tables to a certain time in the past

ALTER TABLE tab_test enable row movement;

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

ALTER TABLE tab_test disable row movement;

3. Check the operation of the table for a certain period of time in the past to confirm the point at which you need to recover

Select Sql_text,last_active_time from V$sqlarea where Last_active_time >to_date (' 20140917 10:00:00 ', ' YYYYMMDD hh24: Mi:ss ') and sql_text like '%tab_test% ';

4, confirm whether to turn on the flash back

Select log_mode,flashback_on from V$database;

Use Flashback to view Oracle Table historical moment data