Oracle Flash back to those things

Turn on the flash back database

ALTER DATABASE flashback on;

ALTER DATABASE open;

Modify Date Time display format:

Alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss ';

View the Flashback database log information in the system view V$flashback_database_log:

SELECT * from V$flashback_database_log;

Flash back to the database:

Flashback database to timestamp (to_date (' 2014-10-11 12:20:11 ', ' yyyy-mm-dd hh24:mi:ss '));

Resetlogs or noresetlogs is required to open after flashback recovery:

ALTER DATABASE open resetlogs/noresetlogs;

Flash Back table:

Flashback table TableName to timestamp (to_date (' 2014-11-10 12:12:12 ', ' yyyy-mm-dd hh24:mi:ss ');

Flash back to Recycle Bin:

Flashback table TableName to before drop;

The following commands can be used to delete data from the Recycle Bin:;

Purge table tablename;

Empty the Recycle Bin:

Purge Dba_recyclebin;

Flash back query:

SELECT * FROM TableName as of timestamp to timestamp (to_date (' 2014-11-12 10:10:10 ', ' yyyy-mm-dd hh24:mi:ss ')) where ...;

Flash back version query:

Select Versions_starttime,version_operation,name,score from tablename versions between timestamp minvalue and MaxValue;

Flashback transaction Query:

Select Table_name,undo_sql from Flashback_tracsaction_query where rownum<5;

This article is from the "accumulation of growth" blog, please be sure to keep this source http://5200644.blog.51cto.com/5190644/1575173

Oracle Flash back to those things