1Z0-083 · Question #86
A database is configured in ARCHIVELOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete…
The correct answer is D. after losing an archived log from before the most recent backup E. after losing the SYSTEM tablespace. If you lose any archive from after the backup, you can't do a complete recovery, so A and C are discarted, also you can't mount the database if you don't have a valid control file. (not B)
Question
A database is configured in ARCHIVELOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)
Options
- Awhen any archived log from, before, or after the most recent backup is corrupt.
- Bafter losing all copies of the control file
- Cafter losing an archived log from after the most recent backup
- Dafter losing an archived log from before the most recent backup
- Eafter losing the SYSTEM tablespace
How the community answered
(52 responses)- A12% (6)
- B6% (3)
- C2% (1)
- D81% (42)
Explanation
If you lose any archive from after the backup, you can't do a complete recovery, so A and C are discarted, also you can't mount the database if you don't have a valid control file. (not B)
Topics
Community Discussion
No community discussion yet for this question.