Data recovery After an update is performed by Oracle update

Operation of the database, often error operation, yesterday after the update operation found that the update is wrong, only to find ways to recover data, now tidy up

First step: Query the time to perform the update operation

Select  from V$sqlarea R ORDER by r.first_load_time Desc;

Execute the above SQL statement in the Sql_text field to find the UPDATE statement that you performed the update operation, and find the update operation time

Step Two: Create a new table and restore the data to the newly created tables

CREATE TABLE T_table_recove-- new table asselect from table1-- as of timestamp to_timestamp ('2016-08-25/11:20:09','yyyy-mm-dd hh24: Mi:ss'); --Time to perform update operations

Step three: Recover data (table1 is the one that you perform the update operation on )

Delete  table1;--Select from t_table_recove;--recover data

The fourth step: check, your updated data is restored again

SELECT * FROM table1

Data recovery After an update is performed by Oracle update