2.86 DB_FLASHBACK_RETENTION_TARGET

DB_FLASHBACK_RETENTION_TARGET specifies the upper limit (in minutes) on how far back in time the database may be flashed back.

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

How far back one can flashback a database depends on how much flashback data Oracle has kept in the fast recovery area.

See Also:

Oracle Data Guard Broker for enabling Flashback Database on Oracle Data Guard primary and target standby databases