1Z0-032 · Question #109
Under which conditions would you perform an incomplete recovery of a database? (Choose all that apply.)
The correct answer is B. when media failure destroys some or all of the online redo logs that were not archived C. when complete recovery cannot be performed because an archived redo log is missing D. when the current control file is lost, is not multiplexed and a backup control file is to be used to open. See the full explanation below for the reasoning.
Question
Under which conditions would you perform an incomplete recovery of a database? (Choose all that apply.)
Options
- Awhen the instance of the database has crashed
- Bwhen media failure destroys some or all of the online redo logs that were not archived
- Cwhen complete recovery cannot be performed because an archived redo log is missing
- Dwhen the current control file is lost, is not multiplexed and a backup control file is to be used to open
How the community answered
(44 responses)- A16% (7)
- B84% (37)
Community Discussion
5
Orla P.May 2, 2026The correct answers are B, C, and D because all three scenarios force you to stop recovery at a point in time before the database is fully current, which is the definition of incomplete recovery. A is wrong because an instance crash triggers automatic crash recovery using the online redo logs that are still intact, so no user-initiated incomplete recovery is needed.
Luis F.Apr 27, 2026I totally picked A at first because a crashed instance sounds catastrophic enough to need incomplete recovery, but then I remembered that instance crashes are handled by automatic crash recovery on startup using the online redo logs, so you only do incomplete recovery when something is actually missing or unrecoverable, like destroyed online redo logs (B), a missing archived log that breaks the chain (C), or when you have to open with a backup control file and can't go all the way to the present (D).
Orla P.Apr 29, 2026Luis nailed the core logic, though it is worth spelling out that with a backup control file you technically can reach the present if all archived logs are intact, the incomplete recovery requirement only kicks in when the control file SCN is ahead of what your log chain can actually prove.
Bao N.Apr 29, 2026Saw this exact question on my sitting last spring and almost second-guessed myself on D, because I kept thinking "lost control file, just restore it" until I remembered that opening with a backup control file forces you down the incomplete recovery path since Oracle can't guarantee all logs are accounted for. B and C are the obvious ones people usually get right, but A is the trap, because a crashed instance just needs crash recovery, which is automatic and complete, so never mark that one.
Hiroshi T.Apr 25, 2026B, C, D. Instance crash triggers automatic instance recovery via SMON, no DBA action needed.