首先要设定DB_RECOVERY_FILE_DESTdb_recovery_file_dest_size;然后再设置。

1、alter system set DB_RECOVERY_FILE_DEST='/u99f';

2、alter system set db_recovery_file_dest_size=2G

3、shutdown immediate

4、startup mount

5、chown -R oracle:oinstall /u99f

6、alter database flashback on;

7、SQL> select flashback_on from v$database;

FLASHBACK_ON

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

YES

1 row selected.