This database parameter specifies the upper limit (in minutes) for how long the system should retain flashback data. It determines the furthest point in the past that one can potentially rewind a database using Flashback Database or Flashback Query. For instance, a setting of 1440 ensures flashback logs are kept to allow reverting changes made up to a full day prior. Note that the actual flashback window may be shorter, limited by disk space allocated for flashback logs.
Managing the duration of retrievable past data is crucial for data recovery and analysis. A well-defined retention period ensures that sufficient historical information is available for correcting errors, examining past trends, or auditing changes, without excessive storage consumption. This capability is essential for maintaining data integrity, particularly in dynamic environments where frequent changes are commonplace. Originally introduced in Oracle Database 10g, this parameter has become a key element of disaster recovery and business continuity strategies.