Re: The retention time with oracle flashback logs are exceeded than db_flashback_retention_target?

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

--
http://www.freelists.org/webpage/oracle-l