Oracle 11g 閃回資料庫

--開啟閃回資料庫

--1.1資料庫需要執行在歸檔模式

sys@TESTDB11>archive log  list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /archive2

Oldest online log sequence     1

Next log sequence to archive   2

Current log sequence           2

--1.2開快速恢復區（就是2個初始化引數）

sys@TESTDB11>show parameter db_recovery_file

NAME                                 TYPE        VALUE

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

db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_

                                                 area

db_recovery_file_dest_size           big integer 4122M

--1.3 開啟閃迴歸檔

sys@TESTDB11>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

sys@TESTDB11>startup mount

ORACLE instance started.

Total System Global Area  855982080 bytes

Fixed Size                  2230792 bytes

Variable Size             641730040 bytes

Database Buffers          209715200 bytes

Redo Buffers                2306048 bytes

Database mounted.

sys@TESTDB11>select flashback_on from v$database;

FLASHBACK_ON

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

NO

sys@TESTDB11>alter database flashback on;

Database altered.

sys@TESTDB11>select flashback_on from v$database;

FLASHBACK_ON

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

YES

sys@TESTDB11>alter database open;

Database altered.