Description: A set of commands and queries related to flashback functionality.
The Flashback Data Archive can be used to automatically track and maintain historical changes to all Oracle data in a highly application transparent, secure and efficient manner. Flashback query allows a user to view the data quickly and easily the way it was at a particular time in the past, even when it is modified and committed, be it a single row or the whole table.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 13th, 2009
FROM v$database;SELECT oldest_flashback_scn,
GRANT flashback ANYTABLETO user1;-------------------------------
startup mount EXCLUSIVE;-- be sure to substitute your SCN
FLASHBACK DATABASE TO SCN 19516617;OR
FLASHBACK DATABASE TO RESTORE POINT bef_damage;/*
FLASHBACK DATABASE TO TIMESTAMP (SYSDATE-1/24);
FLASHBACK DATABASE TO TIMESTAMP timestamp'2002-11-05 14:00:00';
TO TIMESTAMP to_timestamp('2002-11-11 16:00:00', 'YYYY-MM-DD HH24:MI:SS');
*/-- this will failALTER database OPEN;-- this will succeedALTER database OPEN resetlogs;========================SELECT*FROM gv$flashback_database_stat;ALTER system switch logfile;
startup mount EXCLUSIVE;ALTER database flashback off;ALTER database noarchivelog;ALTER database OPEN;SELECT flashback_on, log_mode
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.