Oracle Flashback技术

1、看是否打开闪回功能
 SQL>select log_mode,open_mode,flashback_on from v$database;

2、打开闪回功能
 SQL> shutdown immediate
 SQL> startup mount

 SQL>alter database archivelog;
 SQL> alter database flashback on;
 SQL> alter database open;

 

3、授权

 grant create procedure to fbpub;
 grant create flashback any table to fbpub;
 grant create flashback archive administer to fbpub;
 grant create select any transaction  to fbpub;

 grant select on v_$parameter to fbpub;
 grant execute on dbms_flashback to fbpub；

 

4、系统参数设置

 alter system set job_queue_processes=600 scope=both;
 alter system set undo_retention=10800 scope=both;