Oracle flashback 2

Oracle flashback 2 ORACLEflashbackdatabasesnapshotsqlFlashback database After oracle 10 Gb, oracle can rollback to an prior time by flashback database when there is a error operation or careless operation. in order to come true this target, oracle add another log file group "flashback logs" which records the oracle database's prior operations. it can recover database to a specific time by the snapshot which is equal or less prior time of the specified time. it can recover database to a specific time by archive log file. in order to use the flashback database tool, you need configure the parameter that: db_recover_file_dest db_recover_file_dest_size For oracle 10g, you need to engine the flashback database tool in the mount mode as the SQL: alter database flashback on or alter tablespace ts_name flashback onTo close the flashback database, just change on to off. syntac: flashback database to time to_date (); flashback database to time to timestamp (); flashback database to scn xxx; flashback database to sequence xxx thread 1; flashback database to timestamp (sysdate-1/24 );