nerdexam
Oracle

1Z0-052 · Question #70

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from…

The correct answer is A. 1, 2, 4, 3, 5, 6. When a multiplexed control file is lost while using SPFILE, recovery requires shutting down, copying a good control file, updating the SPFILE parameter, and then restarting the instance before opening the database. The correct ordered sequence is 1, 2, 4, 3, 5, 6.

Performing Backup and Recovery

Question

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order: 1. Shut down the instance, if not already done. 2. Copy one of the remaining control files to a new location. 3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files. 4. Start up the database instance to the NOMOUNT stage. 5. Recover the database to the point of failure of the control file. 6. Open the database. Identify the correct sequence of steps?

Exhibit

1Z0-052 question #70 exhibit

Options

  • A1, 2, 4, 3, 5, 6
  • B2, 4, 3, 5, 6; 1 not required
  • C4, 5, 6, 2, 3; 1 not required
  • D5, 2, 3, 4; 1 and 6 not required

How the community answered

(37 responses)
  • A
    65% (24)
  • B
    22% (8)
  • C
    5% (2)
  • D
    8% (3)

Why each option

When a multiplexed control file is lost while using SPFILE, recovery requires shutting down, copying a good control file, updating the SPFILE parameter, and then restarting the instance before opening the database. The correct ordered sequence is 1, 2, 4, 3, 5, 6.

A1, 2, 4, 3, 5, 6Correct

The instance must first be shut down cleanly (step 1) before any file-level operations are performed. After copying the surviving control file to the new location (step 2), the instance is started to NOMOUNT (step 4) so that ALTER SYSTEM SET CONTROL_FILES ... SCOPE=SPFILE can be issued (step 3) - this command requires a running instance. The database is then recovered (step 5) and opened (step 6).

B2, 4, 3, 5, 6; 1 not required

Skipping the shutdown step is incorrect because attempting to copy a control file while the instance still has it open can lead to corruption or inconsistency.

C4, 5, 6, 2, 3; 1 not required

Starting to NOMOUNT before copying the file and before updating the parameter is out of order, and the CONTROL_FILES parameter update must come before mount/open, not after recovery.

D5, 2, 3, 4; 1 and 6 not required

Omitting steps 1 and 6 is incorrect - a clean shutdown is required before file operations, and the database must be explicitly opened as the final step after recovery.

Concept tested: Oracle control file loss recovery procedure with SPFILE

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/maintaining-control-files.html

Topics

#control file recovery#multiplexing control files#CONTROL_FILES parameter#recovery steps

Community Discussion

No community discussion yet for this question.

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