1Z0-052 · Question #90
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?
The correct answer is C. Configure the database instance for ARCHIVELOG mode. ARCHIVELOG mode is the required configuration for complete point-of-failure recovery because it preserves all redo log data as archived logs.
Question
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?
Options
- AMultiplex all database files.
- BConfigure the Flash Recovery Area.
- CConfigure the database instance for ARCHIVELOG mode.
- DConfigure the FAST_START_MTTR_TARGET initialization parameter.
How the community answered
(38 responses)- A3% (1)
- B3% (1)
- C89% (34)
- D5% (2)
Why each option
ARCHIVELOG mode is the required configuration for complete point-of-failure recovery because it preserves all redo log data as archived logs.
Multiplexing database files protects against individual file loss and I/O errors but does not preserve redo history, so it cannot support complete point-of-failure media recovery.
The Flash Recovery Area is a managed storage location for backup and recovery files but is only a destination - it does not itself enable point-of-failure recovery without ARCHIVELOG mode.
ARCHIVELOG mode instructs Oracle to archive each filled online redo log before it is reused, creating a continuous chain of all database changes. This archived log sequence, combined with a valid backup, enables media recovery to any point in time including the exact moment of failure by replaying every transaction recorded in the redo stream.
FAST_START_MTTR_TARGET limits instance crash recovery time by controlling checkpoint frequency; it does not enable or affect media recovery to the point of failure.
Concept tested: Oracle ARCHIVELOG mode enabling point-of-failure recovery
Source: https://docs.oracle.com/cd/E11882_01/backup.112/e10642/archredo.htm
Topics
Community Discussion
No community discussion yet for this question.