nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • A
    3% (1)
  • B
    3% (1)
  • C
    89% (34)
  • D
    5% (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.

AMultiplex all database files.

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.

BConfigure the Flash Recovery Area.

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.

CConfigure the database instance for ARCHIVELOG mode.Correct

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.

DConfigure the FAST_START_MTTR_TARGET initialization parameter.

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

#ARCHIVELOG mode#point-of-failure recovery#redo logs

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice