Oracle
1Z0-052 · Question #45
1Z0-052 Question #45: Real Exam Question with Answer & Explanation
The correct answer is A: 7, 1, 5, 2, 3, 6, 4. After a SHUTDOWN ABORT, Oracle follows a strict three-phase startup sequence - NOMOUNT, MOUNT, and OPEN - with instance recovery occurring last due to the unclean shutdown.
Managing the Database Instance
Question
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened. 4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?
Options
- A7, 1, 5, 2, 3, 6, 4
- B1, 2, 3, 7, 5, 6, 4
- C7, 1, 4, 5, 2, 3, 6
- D1, 7, 5, 4, 2, 3, 6
Explanation
After a SHUTDOWN ABORT, Oracle follows a strict three-phase startup sequence - NOMOUNT, MOUNT, and OPEN - with instance recovery occurring last due to the unclean shutdown.
Common mistakes.
- B. SGA allocation (1) cannot occur before the parameter file (7) is read, since the parameter file defines all SGA sizing parameters required for memory allocation.
- C. Instance recovery (4) occurs at the end of the OPEN phase, not before background processes (5) are started during NOMOUNT.
- D. The parameter file (7) must be read before SGA allocation (1), so placing step 1 before step 7 violates the NOMOUNT phase prerequisites.
Concept tested. Oracle database startup phases and sequence
Topics
#database startup#SHUTDOWN ABORT#instance recovery#startup phases
Community Discussion
No community discussion yet for this question.