Oracle
1Z0-043 · Question #151
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? (Choose two)
The correct answer is D. You find that the current redo log group is damaged and is not available for recovery. E. You realized while performing a recovery that an archived redo log file needed for recovery is lost. See the full explanation below for the reasoning.
Question
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? (Choose two)
Options
- AYou find that one of the redo log members in each redo log group is lost.
- BYou find that a data file that belongs to the USERS tablespaceis damaged.
- CYou find that a data file that belongs to the SYSTEM tablespaceis damaged.
- DYou find that the current redo log group is damaged and is not available for recovery.
- EYou realized while performing a recovery that an archived redo log file needed for recovery is lost.
How the community answered
(26 responses)- A8% (2)
- B4% (1)
- C15% (4)
- D73% (19)
Community Discussion
No community discussion yet for this question.