You configured the Flash Recovery Area (FRA) for your database. The database instance is running in
ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which two files are removed automatically if the space is required in the FRA as per the retention
policy? (Choose two.)
A.
Flashback log files
B.
Backups that have become obsolete
C.
User managed backups of the data files and control files
D.
Archived redo log files that have multiple copies in a different archive location and not backed up
The amount of disk space allocated to the fast recovery area depends on the size and activity level of the database . Typically , for fast recovery, the larger the area , the more helpful .
Ideally, the flash recovery area should be large enough to store a copy of the data files and control files ,
And based retention policy required to recover the database flashback logs from the reservation of backup, online redo logs and archive logs.
( In short , the flash recovery area should be at least twice the size of the database , so you can keep a backup and archive several
Log. )
Fast Recovery Area space management is controlled by the backup retention policy .
Oracle DB automatically manage the memory by deleting files you no longer need, this is retention policy
The flash recovery area should be at least twice the size of the database, so you can keep a backup and archive several Log.
Fast Recovery Area is controlled by the backup retention policy.
Retention policy determine when files become obsolete.
Oracle DB automatically manage the memory by deleting files you no longer need.
Flash recovery area’s deletion of flashback logs:
A flashback log is created whenever necessary to satisfy the flashback retention target, as long as there is enough space in the flash recovery area.
A flashback log can be reused, once it is old enough that it is no longer needed to satisfy the flashback retention target.
If the database needs to create a new flashback log and the flash recovery area is full or there is no disk space, then the oldest flashback log is reused instead.
FLASH – OBSOLETE