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.)

Question

Accepted Answer

A. Flashback log files Flashback log files are fully managed by the Oracle database engine within the FRA - when space is required and the configured DB_FLASHBACK_RETENTION_TARGET has been satisfied, Oracle automatically deletes the oldest flashback logs without DBA intervention. B. Backups that have become obsolete Backups tracked by RMAN that are marked obsolete according to the configured retention policy (either REDUNDANCY or RECOVERY WINDOW) are automatically eligible for deletion by the FRA space management algorithm when additional space is needed.

Answer

C. User managed backups of the data files and control files User-managed backups created with OS-level copy commands are not registered in the RMAN repository and therefore are completely outside the scope of FRA automatic space management - the DBA must manually remove them.

Answer

D. Archived redo log files that have multiple copies in a different archive location and not backed up Archived redo log files that have multiple copies in another archive destination but have NOT yet been backed up are not eligible for automatic deletion from the FRA, because the backup retention policy requires them to be backed up before Oracle will consider them removable.

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…

Question

Options

How the community answered

Why each option

Topics

Community Discussion