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.)
A.
the archived log deletion policy
B.
the backup optimization policy
C.
the backup retention policy
D.
using guaranteed UNDO retention
E.
the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
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
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.
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.
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..
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RinD
Highly Voted 3 years, 2 months agoABAJ
3 years, 1 month agoantonica
Most Recent 3 months, 3 weeks agoantonica
3 months, 3 weeks agoantonica
3 months, 3 weeks agoflaviogcmelo
10 months, 2 weeks ago_gio_
1 year agoScottL
1 year, 2 months agovkra
1 year, 4 months agoNeil107
2 years, 11 months agoniabs
3 years agoFranta1
1 year, 9 months agoObserverPL
3 years, 1 month agogon20
3 years, 2 months ago