Oracle table data recovery and oracle Data Recovery

Oracle table data recovery and oracle Data Recovery

When you accidentally delete data in a table for table data recovery, you generally do not need to operate on the table any more. You can recover the data in the table as follows.

Scenario: If data in table test is accidentally deleted, the following methods can be used to restore data in the table:

Method 1: create a backup table to store data three hours ago

Create table tabletest_2014bak nologging as select * from tabletest as of timestamp sysdate-21/24 where name! = 'Boat ';

Restore data 3 hours ago

Method 2: Restore the data in table test to a certain time point, which must be earlier than the current time.

Alter table tabletest enable row movement; Flashback table tabletest to timestamp to_timestamp ('2017-12-30 17:00:00 ', 'yyyy-mm-dd hh24: mi: ss ');