Oracle Database accidental deletion and data recovery

Last week, I deleted the production data because of a temporary embarrassment.

The delete statement is used, and commit is returned quickly.

So --- "has a cup.

----------------------------------------------------

The following two statements are found:

Alter table tablename ENABLE row movement;

Flashback table tablename to timestamp to_timestamp ('2017-09-13 13:00:00 ', 'yyyy-mm-dd hh24: mi: ss ');

------------------------------------------------------

Remember the delete --- commit statement that runs around half past two;

But it was recovered to 13:00:00, as I should have.

(In other words, it's cool at this time. Remember: It's okay. Don't take it for granted)

------------------------------------------------------

The data I accidentally deleted was indeed returned, but it was suddenly reflected the next day that the data inserted between 13:00:00 and 14:30:00 was still unavailable (I tried it in the test environment, the data for this period of time should be gone, because this table is the original list, and the directory will be continuously poll, parse the file, and insert details. So, I am really panic)

------------------------------------------------------

Fortunately, we found the lost data through other channels. Unfortunately, we were lucky.

------------------------------------------------------

Therefore, if this problem persists next time, we strongly recommend that you create a temporary table to back up the data in the current table before restoration, and then confirm that the data is not inserted or updated after backup, at this time, use the preceding statement to restore the table to a certain time, and then integrate the two tables.

------------------------------------------------------

I am so arrogant that there are more and more problems with the expression ...... Sad reminder ......