1Z0-067 · Question #185
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance. LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 =…
The correct answer is C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in. SQL> show parameter log_archive_min_succeed_dest ------------ ---- ---------- log_archive_min_succeed_dest integer 1 https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11346
Question
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance. LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch' LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch' L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY' Identify the statement that correctly describes these settings.
Options
- AAn online redo log file is not allowed to be overwritten if the archived log file cannot be created in
- BOptional destinations cannot use the fast recovery area.
- CAn online redo log file is not allowed to be overwritten if the archived log file cannot be created in
- DThese settings work only if log__archive_min_succeed_dest is set to a value of 4.
How the community answered
(51 responses)- A6% (3)
- B2% (1)
- C80% (41)
- D12% (6)
Explanation
SQL> show parameter log_archive_min_succeed_dest ------------ ---- ---------- log_archive_min_succeed_dest integer 1 https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11346
Topics
Community Discussion
No community discussion yet for this question.