Shulou(Shulou.com)06/01 Report--

Open the flashback database

Alter database flashback on

Alter database open

Modify the date and time display format:

Alter session set nls_date_format='yyyy-mm-dd hh34:mi:ss'

View the flashback database log information in the system view v$flashback_database_log:

Select * from v$flashback_database_log

Flashback database:

Flashback database to timestamp (to_date ('2014-10-11 12-12-12-12-20-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-

Resetlogs or noresetlogs is required after flashback recovery:

Alter database open resetlogs/noresetlogs

Flashback table:

Flashback table tablename to timestamp (to_date ('2014-11-10 12-12-12-12-14-12-12-12-12-12-12-12-12-12-12-12-12-12-13-11-10-12)

Flash the Recycle Bin:

Flashback table tablename to before drop

To delete data from the Recycle Bin, you can use the following command:

Purge table tablename

Empty the Recycle Bin:

Purge dba_recyclebin

Flashback query:

Select * from tablename as of timestamp to timestamp (to_date ('2014-11-12 10 hh34:mi:ss')) where.

Flashback 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.