Oracle
1Z0-043 · Question #73
An RMAN backup job fails, displaying the following error: ORA-19809: limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to…
The correct answer is D. change the backup retention policy to retain the backups for a smaller period of time E. increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter. See the full explanation below for the reasoning.
Question
An RMAN backup job fails, displaying the following error:
ORA-19809: limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future? (Choose two.)
Options
- Atake the backup of the flash recovery area less frequently
- Bincrease the value of the UNDO_RETENTION initialization parameter
- Cchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
- Dchange the backup retention policy to retain the backups for a smaller period of time
- Eincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
- Fincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
How the community answered
(23 responses)- A13% (3)
- B4% (1)
- D74% (17)
- F9% (2)
Community Discussion
No community discussion yet for this question.