SQL> set linesize 1000
SQL> set pagesize 1000
SQL> show parameter DB_FLASHBACK_RETENTION_TARGET

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
db_flashback_retention_target        integer                           1440
SQL>

DB_FLASHBACK_RETENTION_TARGET specifies the upper limit (in minutes) on how far back in time the database may be flashed back. How far back one can flashback a database depends on how much flashback data Oracle has kept in the flash recovery area. http://www.cndba.cn/hbhe0316/article/108661

但是实际测试中发现， 只要 flashback 区足够大，归档文件不删除，系统都可以回退到超过1天的某个历史时间点， 没有对闪回日志文件进行覆盖 。 http://www.cndba.cn/hbhe0316/article/108661

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle