Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

RMAN-06823

flashback command failed due to low value of DB_FLASHBACK_RETENTION_TARGET

Cause

An attempt to flashback failed due to the NULL value for OLDEST_FLASHBACK_SCN or OLDEST_FLASHBACK_TIME in V$FLASHBACK_DATABASE_LOG. This failure can happen when the initial creation of standby is not consistent or when there is not enough space in FRA for 1 hours worth of flashback data.


Action

Increase the value for DB_FLASHBACK_RETENTION_TARGET to a higher value and check the value of OLDEST_FLASHBACK_SCN and OLDEST_FLASHBACK_TIME in V$FLASHBACK_DATABASE_LOG.