Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)
Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)
To manage space availability in the fast recovery area for a database in ARCHIVELOG mode that uses Flashback Database, the archived log deletion policy and the backup retention policy are essential. The archived log deletion policy determines when archived logs can be deleted, ensuring that unnecessary logs do not consume space. The backup retention policy defines how long backups are kept, which also influences the space usage in the fast recovery area by removing obsolete backups.
AC correct RMAN automatically manages files in the fast recovery area by deleting obsolete backups and archiving files no longer required for recovery. https://docs.oracle.com/en/database/oracle/oracle-database/18/ssdbi/about-the-fast-recovery-area-and-the-fast-recovery-area-disk-group.html#GUID-05343E2B-24CF-427E-A068-9AC2104BEF81
correct
It's AC. F has absolutely nothing to do with the space requirements in the FRA.
Agree with RinD - A and C
I AM not sure about ac. FLASHBACK database use FLASHBACK logs not backup neather archvelogs. Can someouem explain me. Thx
A Flashback Database operation applies to the whole database. You cannot flash back individual tablespaces. A Flashback Database operation is similar to a database point-in-time recovery (DBPITR) performed with RECOVER, but RMAN uses flashback logs to undo changes to a point before the target time or SCN. RMAN automatically restores from backup any archived redo log files that are needed and recovers the database to make it consistent. RMAN never flashes back data for temporary tablespaces. The earliest SCN that can be used for a Flashback Database operation depends on the setting of the DB_FLASHBACK_RETENTION_TARGET initialization parameter, and on the actual retention of flashback logs permitted by available disk. View the current database SCN in V$DATABASE.CURRENT_SCN.
AF i guest
19c (New Feature) : Auto Space Management for Flashback Logs in the Fast Recovery Area (Doc ID 2465562.1) 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.
manage so AC
A, C Correct. B can have an impact, but it doesn't "manage" space availability in the FRA
A+C https://docs.oracle.com/en/database/oracle/oracle-database/19/ssdbi/about-the-fast-recovery-area-and-the-fast-recovery-area-disk-group.html#GUID-05343E2B-24CF-427E-A068-9AC2104BEF81
I will choose A and F. Because if backups are not located in the FRA then C is false
Please be aware, that option F is talking about the destination for FRA. If there is an option with DB_RECOVERY_FILE_DEST_SIZE parameter, I will vote for it..
I think A - F