1.87 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