Prev Question
Next Question

You want to set the following initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = ‘LOCATION=/disk1/arch’
LOG_ARCHIVE_DEST_2 = ‘LOCATION=/disk2/arch’
LOG_ARCHIVE_DEST_3 = ‘LOACTION=/disk3/arch’
LOG_ARCHIVE_DEST_4 = ‘LOCATION=/disk4/arch MANDATORY’
Identify the statement that correctly describes this setting.

A.
The MANDATORY location must be a flash recovery area.

B.
The optional destinations may not use the flash recovery area.

C.
This setting is not allowed because the first destination is not set as MANDATORY.

D.
The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth
destination.

Explanation:
MANDATORY
Specifies that filled online log files must be successfully archived to the destination before they can be reused.
If MANDATORY is not specified, then, by default, the destination is considered to be optional.
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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *