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

From: Quanwen Zhao <quanwenzhao_at_gmail.com>
Date: Sat, 24 Jun 2023 18:08:52 +0800
Message-ID: <CABpiuuRDz7kvvRZ=wPJgOOqojTtNbLupm9jK8ue=BWNytcuHNg_at_mail.gmail.com>



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
Received on Sat Jun 24 2023 - 12:08:52 CEST

Original text of this message