Oracle Data Sheet mistakenly deleted recovery Flashback

1. Pre-conditions. The RecycleBin parameter opens.

Verify that the parameters are open:

SHOW PARAMETER RecycleBin

2. If the parameter is not open, you need to open it, and restart the database method to

set recyclebin=on scope=spfile;

3. Log in to the database

 as sysdba# shut down database shutdown immediate# Open database startup

4. Create a table test

Create table ZHAOBSH (Test varchar), insert into table ZHAOBSH values ("zhaobsh" c4> "); Select  from zhaobshdrop Table Zhaobsh

5. Roll back the table

Flashback TABLE Zhaobsh to before DROP;

Technical content is relatively low but useful if recyclebin is turned on and the drop table is in a relatively short time.

6. Methods for rolling back to a time node

Guarantee table can be movement

Command

ALTER TABLE zhaobsh ENABLE ROW movement;

Roll back the table to five minutes ago

' 5 '

Rollback to the syntax of a precise time node

FLASHBACK TABLE Zhaobsh to TIMESTAMP to_timestamp ('2018-06-20 10:04:01 PM','  Yyyy-mm-dd HH:MI:SS AM')

Note that the time here is that the database time is not the client's time needs to be strictly matched or the result is incorrect.

Oracle Data Sheet mistakenly deleted recovery Flashback