Upgrade Oracle DBA 11g to Oracle Database 12c — Question 52

Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

Answer options

• A. The database instance hangs and the redo log files are not overwritten.
• B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
• C. The database instance is shutdown immediately.
• D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee

Correct answer: D

Explanation

The correct answer is D because when a mandatory destination is unavailable, the database will use other available destinations to ensure that the archived redo log files are created, fulfilling the requirement of LOG_ARCHIVE_MIN_SUCCEED_DEST. Option A is incorrect as the instance does not hang; it continues functioning by utilizing other destinations. Option B is wrong because the logs are not written to the fast recovery area but rather to the next available locations. Option C is also incorrect as the database does not shut down immediately in this scenario.