nerdexam
Oracle

1Z0-052 · Question #45

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…

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

How the community answered

(30 responses)
  • A
    77% (23)
  • B
    7% (2)
  • C
    3% (1)
  • D
    13% (4)

Why each option

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.

A7, 1, 5, 2, 3, 6, 4Correct

The correct order is: read the parameter file (7) to determine instance configuration, allocate the SGA (1) and start background processes (5) during NOMOUNT, read the control file (2) during MOUNT, then during OPEN - open redo log files (3), check data file headers for consistency (6), and finally start instance recovery (4) because the prior SHUTDOWN ABORT left the database in an inconsistent state requiring crash recovery.

B1, 2, 3, 7, 5, 6, 4

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.

C7, 1, 4, 5, 2, 3, 6

Instance recovery (4) occurs at the end of the OPEN phase, not before background processes (5) are started during NOMOUNT.

D1, 7, 5, 4, 2, 3, 6

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

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/starting-up-and-shutting-down.html

Topics

#database startup#SHUTDOWN ABORT#instance recovery#startup phases

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice