DB_FLASHBACK_RETENTION_TARGET

Property Description

Parameter type

Integer

Default value

131072 (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.

See Also:

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