Oracle
1Z0-083 · Question #10
A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery…
The correct answer is C. after losing all members of the CURRENT online redo log group D. after losing all copies of the control file. If you lose all control the required incomplete recovery. if incomplete recovery then db must be open in resetlog option.
Perform Backup and Recovery
Question
A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)
Options
- Aafter losing a SYSAUX tablespace data file
- Bafter losing all members of an INACTIVE online redo log group
- Cafter losing all members of the CURRENT online redo log group
- Dafter losing all copies of the control file
- Eafter losing an UNDO tablespace that is in use
How the community answered
(52 responses)- A6% (3)
- B10% (5)
- C81% (42)
- E4% (2)
Explanation
If you lose all control the required incomplete recovery. if incomplete recovery then db must be open in resetlog option.
Topics
#incomplete recovery#CURRENT redo log#control file loss#point-in-time recovery
Community Discussion
No community discussion yet for this question.