nerdexam
Oracle

1Z0-062 · Question #316

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

The correct answer is C. 2, 3, 1, 6. To enable ARCHIVELOG mode in an Oracle database, the database must first be shut down, then mounted, and the ALTER DATABASE ARCHIVELOG command executed before opening the database.

Performing Backup and Recovery

Question

Your database is in NOARCHIVELOG mode. You want to enable archiving for the database. Examine the steps: 1. Execute the ALTER DATABASE ARCHIVELOG 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. Identify the required steps in the correct sequence.

Options

  • A4, 2, 5, 1, 6
  • B1, 2, 3, 4, 6
  • C2, 3, 1, 6
  • D2, 5, 1, 6

How the community answered

(48 responses)
  • A
    2% (1)
  • B
    10% (5)
  • C
    81% (39)
  • D
    6% (3)

Why each option

To enable ARCHIVELOG mode in an Oracle database, the database must first be shut down, then mounted, and the ALTER DATABASE ARCHIVELOG command executed before opening the database.

A4, 2, 5, 1, 6

This sequence is incorrect because the database must be shut down and mounted before ALTER DATABASE ARCHIVELOG can be executed, and setting DB_RECOVERY_FILE_DEST is typically done via ALTER SYSTEM and not a core step for mode change.

B1, 2, 3, 4, 6

This sequence is incorrect because the database needs to be shut down before starting in mount mode, and setting DB_RECOVERY_FILE_DEST is a separate configuration, not a mandatory step for enabling ARCHIVELOG mode itself.

C2, 3, 1, 6Correct

To change from NOARCHIVELOG to ARCHIVELOG mode, the database must be shut down (step 2) and then started in MOUNT mode (step 3). While in MOUNT mode, the `ALTER DATABASE ARCHIVELOG` command (step 1) is executed to enable archiving. Finally, the database can be opened (step 6) for normal operations.

D2, 5, 1, 6

This sequence is incorrect because the database must be mounted, not started in NOMOUNT mode, to execute the ALTER DATABASE ARCHIVELOG command.

Concept tested: Oracle ARCHIVELOG mode enablement

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-archive-logs.html#GUID-00A91D3C-4C9D-46F5-BEFF-B474C64005B2

Topics

#ARCHIVELOG mode#NOARCHIVELOG mode#database startup states#database configuration

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice