activate the flashback in 11G

SQL> conn / as sysdba
已连接。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL>
SQL> startup mount
ORACLE 例程已经启动。

Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 352322000 bytes
Database Buffers 176160768 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
SQL> flashback database to restore point mypoint;
flashback database to restore point mypoint
*
第 1 行出现错误:
ORA-38726: 未启用闪回数据库事件记录。

check the restore point record from the view.

SQL> select * from v$restore_point;

SCN DATABASE_INCARNATION# GUA STORAGE_SIZE
---------- --------------------- --- ------------
TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE
--------------------------------------------------------------------------- ---
NAME
--------------------------------------------------------------------------------
2398559 2 NO 0
27-12月-10 01.38.12.000000000 下午
NO
GOLD


SCN DATABASE_INCARNATION# GUA STORAGE_SIZE
---------- --------------------- --- ------------
TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE
--------------------------------------------------------------------------- ---
NAME
--------------------------------------------------------------------------------
2607100 2 NO 0
27-12月-10 03.19.33.000000000 下午
NO
MYPOINT

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO

In 11G we can activate the flashback when database is open:

SQL> alter database flashback on;

数据库已更改。

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
YES