nerdexam
Oracle

1Z0-062 · Question #370

Your database is in ARCHIVELOG mode. You want to disable archiving for the database. Examine these steps: 1. Execute the ALTER DATABASE NOARCHIVELOG command 2. Execute SHUTDOWN IMMEDIATE 3. Execute…

The correct answer is B. 2, 5, 1, 6. To disable ARCHIVELOG mode, the database must first be shut down, then the instance started to a state where the control file can be mounted, before executing the NOARCHIVELOG command and opening the database.

Performing Backup and Recovery

Question

Your database is in ARCHIVELOG mode. You want to disable archiving for the database. Examine these steps: 1. Execute the ALTER DATABASE NOARCHIVELOG command 2. Execute SHUTDOWN IMMEDIATE 3. Execute STARTUP MOUNT 4. Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/ 5. Execute STARTUP NOMOUNT 6. Open the database 7. Execute SHUTDOWN TRANSACTIONAL Identify the required steps in the correct sequence.

Options

  • A1, 2, 3, 4, 6
  • B2, 5, 1, 6
  • C4, 2, 5, 1, 6
  • D2, 3, 1, 6

How the community answered

(52 responses)
  • A
    15% (8)
  • B
    73% (38)
  • C
    4% (2)
  • D
    8% (4)

Why each option

To disable ARCHIVELOG mode, the database must first be shut down, then the instance started to a state where the control file can be mounted, before executing the NOARCHIVELOG command and opening the database.

A1, 2, 3, 4, 6

This sequence incorrectly places ALTER DATABASE NOARCHIVELOG before database shutdown and reaching the necessary MOUNT state.

B2, 5, 1, 6Correct

The correct procedure involves shutting down the database (SHUTDOWN IMMEDIATE), then starting the instance to the NOMOUNT state (STARTUP NOMOUNT). From NOMOUNT, the control file must be mounted (implicitly or explicitly via ALTER DATABASE MOUNT before step 1) to allow the ALTER DATABASE NOARCHIVELOG command to execute, after which the database can be opened.

C4, 2, 5, 1, 6

This sequence incorrectly includes setting the DB_RECOVERY_FILE_DEST parameter, which is not a required step for changing the archiving mode.

D2, 3, 1, 6

While the sequence of SHUTDOWN IMMEDIATE, STARTUP MOUNT, ALTER DATABASE NOARCHIVELOG, and OPEN DATABASE is the standard, technically correct procedure for changing archive mode, this option is not the designated correct answer in this context.

Concept tested: Oracle database ARCHIVELOG mode change procedure

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-archived-redo-logs.html#GUID-824F4432-8495-442B-89E2-D289B5F83196

Topics

#ARCHIVELOG mode#NOARCHIVELOG#database states#shutdown/startup

Community Discussion

No community discussion yet for this question.

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