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

Thank you so much Hemant :-).

23c does the apparently change for the location of flashback logs, this is very cool, which is flexible as the archive log is able to put outside of FRA. Hemant K Chitale <hemantkchitale_at_gmail.com> 于2023年7月31日周一 11:15写道：

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