首先要设定DB_RECOVERY_FILE_DEST和db_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.
转载于:https://blog.51cto.com/water1997/747330