Exam 1z0-063 topic 1 question 223 discussion

Actual exam question from Oracle's 1z0-063

Question #: 223
Topic #: 1

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?

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_1 parameter is ignored and the archived redo log files are created in the next two available locations to

Show Suggested Answer

Suggested Answer: D 🗳️

by alipilot2006 at April 26, 2019, 9:10 a.m.

Comments

Submit Cancel

mihanik

4 years, 5 months ago

Looks like A https://docs.oracle.com/database/121/SBYDB/log_arch_dest_param.htm#GUID-C4AD4812-D4A6-41C9-8F03-4C87B64F1D4D At least one destination must succeed, even if all destinations are optional. If archiving to an optional destination fails, the online redo log file is still available for reuse and may be overwritten eventually. However, if the archival operation of a mandatory destination fails, online redo log files cannot be overwritten.

upvoted 1 times

...

Sugar

4 years, 5 months ago

yes A is correct

upvoted 2 times

...

sherifelia

4 years, 10 months ago

Answer A

upvoted 1 times

...

alipilot2006

5 years, 7 months ago

The answer is "A"

upvoted 3 times

...

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam