Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
In Oracle Database 19c and later releases, flashback logs are managed more efficiently to optimize space usage. Flashback logs beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET are proactively deleted before there is space pressure, ensuring space is available when needed. Additionally, if the DB_FLASHBACK_RETENTION_TARGET is set to a lower value, flashback logs that exceed the new retention period are automatically purged to comply with the updated target.
Starting with Oracle Database Release 19c, the management of space in the fast recovery area is simplified. Oracle Database monitors flashback logs in the fast recovery area and automatically deletes flashback logs that are beyond the retention period. When the retention target is reduced, flashback logs that are beyond the retention period are deleted immediately. In scenarios where a sudden workload spike causes a large number of flashback logs to be created, the workload is monitored for a few days before deleting flashback logs that are beyond the retention period. This avoids the overhead of recreating the flashback logs, if another peak workload occurs soon after. Correct answer: A,C
Correct answer A,C
I think its A and C. starting from 19c. Starting with Oracle Database Release 19c, Oracle Database monitors flashback logs in the fast recovery area and automatically deletes flashback logs that are beyond the retention period (Not Waiting for FRA Crunch). When the retention target is reduced, flashback logs that are beyond the retention period are deleted immediately.
AC 19c (New Feature) : Auto Space Management for Flashback Logs in the Fast Recovery Area (Doc ID 2465562.1)
correct ans: AC Until Oracle Database 19c, flashback logs that are beyond the flashback retention period set through the db_flashback_retention_target initialization parameter are marked as reclaimable but are not purged until there is space pressure. The reclaimable flashback logs are deleted only when the fast recovery area is running out of space. The DBA cannot manually delete the flashback logs. This means that when a backup needs to be completed and the FRA is 100 % full, the backup operation must wait until the reclaimable flashback logs are purged to free space in the FRA. With Oracle Database 19c, flashback logs beyond the retention period are proactively deleted without degrading the flashback performance and before there is space pressure. The flashback log space is tracked and monitored proactively to provide flashback log retention in a transparent manner.
So they are A, B corrects and not C!? C is saying BEFORE the space pressure, B is saying AFTER instead.
I think, A, B https://blogs.oracle.com/maa/flashback-database-and-flashback-logs
19c (New Feature) : Auto Space Management for Flashback Logs in the Fast Recovery Area (Doc ID 2465562.1)
agreed with AC
correct A,B
A and D are true. Oracle until the end will try to don't delete flashback logs. "Proactively" makes sentences false. D is absolutely possible, you can selected on data dictionary tables and set up an event trigger (ex. Database logon, DB scheduler, etc.) to purge logs, but it is not recommended.
A and B for me. The oldest flashback logs may be deleted if there is space pressure in the FRA where the flashback logs are stored. https://docs.oracle.com/en/database/oracle/oracle-database/23/haovw/oracle-flashback-best-practices.html#GUID-3E255563-B001-4AC1-A2E0-1884BF58D6C0
A C correct
AC https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/maintaining-rman-backups.html#GUID-26C1A1E8-5555-4399-9DD1-39BA90E45A0C
Correc Ans:A,C as per 19c (New Feature) : Auto Space Management for Flashback Logs in the Fast Recovery Area (Doc ID 2465562.1)
AB. https://tekdba.wordpress.com/2019/07/18/oracleflashbackdatabase/#:~:text=The%20Only%20quick%20way%20we,Not%20Waiting%20for%20FRA%20Crunch).
correct AB
reviewing the indicated by ald85 A, B