Init parameterBackup & recovery

DB_FLASHBACK_RETENTION_TARGET

What it controls

Minutes of flashback logs to keep for Flashback Database.

Know this before you change it

It's a target that Oracle drops below when the Fast Recovery Area is short of space. Guaranteed restore points are kept regardless.

Default: 1440

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'db_flashback_retention_target';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'db_flashback_retention_target' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET db_flashback_retention_target = 1440 SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET db_flashback_retention_target SCOPE = SPFILE SID = '*';

Related scripts

• Flashback status and restore pointsWhether flashback is on, how far back you can go, and every restore point. A forgotten guaranteed restore point will keep filling the FRA until it's…

Open in the parameter referenceOracle's reference

More in Backup & recovery

• DB_RECOVERY_FILE_DESTLocation of the Fast Recovery Area, for archived logs, backups and flashback logs.
• DB_RECOVERY_FILE_DEST_SIZEThe most space the Fast Recovery Area may use.
• CONTROL_FILE_RECORD_KEEP_TIMEDays that reusable backup and archived log records stay in the control file.
• DB_BLOCK_CHECKSUMWhether blocks carry a checksum that's verified on read.
• DB_BLOCK_CHECKINGLogical consistency checks on blocks when they change.
• DB_LOST_WRITE_PROTECTRecords block versions in redo so lost writes can be detected.