What would you do to reclaim the used space in the Flash Recovery Area?
You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file:ORA19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)
Question:
What would you do to reclaim the used space in the Flash Recovery Area?
Options:
Back up the Flash Recovery Area.
Decrease the retention time for the database backup and flashback log files.
Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.
Manually delete all the expired backup sets from the Flash Recovery Area by using operating system (OS) commands.
Correct Answer
The Correct Answer for this Question is
Back up the Flash Recovery Area.
Decrease the retention time for the database backup and flashback log files.