There seems to be an alternative (in 23c) to have the flashback logs
created in a separate location (folder).
That provides the advantage that the Flashback Logs don't take up too much
space in the FRA.
https://orabliss.blogspot.com/2023/04/create-flashback-logs-outside-fra.html
Hemant K Chitale
On Sat, Jun 24, 2023 at 6:10 PM Quanwen Zhao <quanwenzhao@xxxxxxxxx> wrote:
Hello my folks and friends :-),
I've found out the retention time with oracle flashback logs are exceeded
than db_flashback_retention_target on several number of oracle databases
enabling flashback database whatever data guard primary or physical standby
from one of my customers.
Such as, db_flashback_retention_target is setting 2880 (two days) but
oracle flashback logs are generated now during in the period of 5 days. By
the way the size of flash recovery area is 1500g and flashback logs are
about 400g in 5 days and I've never created guarantee restore point.
I wonder the mechanism of oracle flashback logs real retention time except
two number of facts - db_flashback_retention_target and
db_recovery_file_dest_size.
Thanks beforehand!
Best Regards
Quanwen Zhao