oracle数据闪回

1.打开闪回开关：
sqlplus / as sysdba
SQL>

alter system set db_recovery_file_dest_size=1G scope=both;

alter system set db_recovery_file_dest='D:\ORACLE\flashback'  scope=both;

shutdown immediate;

startup mount;

alter database archivelog;

alter database flashback on;

alter database open;

再进行确认：
SQL> select flashback_on from V$database;
FLASHBACK_ON
------------------
YES

LINUX系统：
cd /u01
mkdir flashback(生成闪回目录)
SQL> alter system set db_recovery_file_dest_size=30G scope=both;
SQL> alter system set db_recovery_file_dest='/u01/flashback'  scope=both;
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database flashback on;
SQL> alter database open;
三
再进行确认：
SQL> select flashback_on from V$database;
FLASHBACK_ON
------------------
YES