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