DB_FLASHBACK_RETENTION_TARGET

Property Description
Parameter type Integer
Default value 1440 (minutes)
Modifiable ALTER SYSTEM ... SID='*'
Range of values 0 to 231 - 1
Basic No

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 fast recovery area.