oracle開啟閃回

1. 查看數據庫是否是歸檔模式：
   

SQL> show parameter db_flashback;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_flashback_retention_target        integer     1440

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /oradata/arch/matrixdg

Oldest online log sequence     65

Next log sequence to archive   0

Current log sequence           67

2.設置閃回參數：

SQL> show parameter db_recovery;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest                string      /u2/oracle/fast_recovery_area

db_recovery_file_dest_size           big integer 4122M

如上：db_recovery_file_dest為閃回路徑，db_recovery_file_dest_size為閃回區大小。

SQL> show parameter flashback;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_flashback_retention_target        integer     1440

如：db_flashback_retention_target閃回保留時間

3.關閉數據庫，啟用閃回

SQL>shutdown immediate

SQL>startup mount

SQL>alter database flashback on;

SQL>alter database open;

4.查詢閃回狀態

SQL> select flashback_on from v$database;

FLASHBACK_ON

------------------

YES