1Z0-062 Question #316: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

A. 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.
B. 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.
D. 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

Reference. 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