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.
Question
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)- A2% (1)
- B10% (5)
- C81% (39)
- D6% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.