nerdexam
Oracle

1Z0-052 · Question #150

You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order: 1. Shut down the instance…

The correct answer is C. 1, 3, 2, 5; 4 not required. Enabling ARCHIVELOG mode requires the database to be mounted but not open, and setting DB_RECOVERY_FILE_DEST is optional since LOG_ARCHIVE_DEST_n parameters can serve as the archive destination.

Performing Backup and Recovery

Question

You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order: 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task?

Options

  • A4, 1, 3, 2, 5
  • B1, 3, 4, 5, 2
  • C1, 3, 2, 5; 4 not required
  • D4, 1, 5, 2; 3 not required
  • E1, 3, 4, 5; 2 not required

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    7% (2)
  • C
    85% (23)
  • D
    4% (1)

Why each option

Enabling ARCHIVELOG mode requires the database to be mounted but not open, and setting DB_RECOVERY_FILE_DEST is optional since LOG_ARCHIVE_DEST_n parameters can serve as the archive destination.

A4, 1, 3, 2, 5

This sequence treats step 4 (DB_RECOVERY_FILE_DEST) as required, but it is not mandatory for enabling archiving since LOG_ARCHIVE_DEST_n parameters are a valid alternative archive destination.

B1, 3, 4, 5, 2

This sequence includes step 4 as required and places it after mounting, but DB_RECOVERY_FILE_DEST is optional and omitting it does not prevent ARCHIVELOG mode from being enabled.

C1, 3, 2, 5; 4 not requiredCorrect

The correct order is shut down (1), start up and mount (3), execute ALTER DATABASE ARCHIVELOG (2), then open (5). The database must be in MOUNT state for ALTER DATABASE ARCHIVELOG to succeed. Step 4 (DB_RECOVERY_FILE_DEST) is not required because LOG_ARCHIVE_DEST_n parameters can designate the archive destination instead.

D4, 1, 5, 2; 3 not required

This sequence omits step 3 (mounting), but ALTER DATABASE ARCHIVELOG cannot be executed unless the database is in MOUNT state - running it on an open database will fail.

E1, 3, 4, 5; 2 not required

This sequence omits step 2 (ALTER DATABASE ARCHIVELOG), which is the mandatory command that actually switches the database from NOARCHIVELOG to ARCHIVELOG mode.

Concept tested: Enabling Oracle database ARCHIVELOG mode procedure

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-archived-redo-log-files.html

Topics

#ARCHIVELOG mode#database startup sequence#DB_RECOVERY_FILE_DEST#archive log

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice