Oracle Database 12c: Installation and Administration — Question 210

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.

Answer options

• A. 4, 2, 5, 1, 6
• B. 1, 2, 3, 4, 6
• C. 2, 3, 1, 6
• D. 2, 5, 1, 6

Correct answer: C

Explanation

The correct answer is C because you must first shut down the database (step 2) and then mount it (step 3) before executing the command to enable archiving (step 1). Steps 4 and 5 are not required in the correct sequence necessary to enable archiving, thus making options A, B, and D incorrect.