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