nerdexam
Oracle

1Z0-062 · Question #329

What action must you take to ensure complete database recovery till the point of failure?

The correct answer is D. Configure the database to run in ARCHIVELOG mode. To guarantee complete database recovery up to the point of failure, the database must be configured to operate in ARCHIVELOG mode. This mode ensures that a continuous stream of archived redo logs is available for applying all committed transactions during recovery.

Performing Backup and Recovery

Question

What action must you take to ensure complete database recovery till the point of failure?

Options

  • AMultiplex the control files
  • BDuplex the RMAN backup sets.
  • CMultiplex the online redo log files.
  • DConfigure the database to run in ARCHIVELOG mode.

How the community answered

(28 responses)
  • A
    7% (2)
  • B
    4% (1)
  • D
    89% (25)

Why each option

To guarantee complete database recovery up to the point of failure, the database must be configured to operate in ARCHIVELOG mode. This mode ensures that a continuous stream of archived redo logs is available for applying all committed transactions during recovery.

AMultiplex the control files

Multiplexing control files provides redundancy for the control file itself, protecting against loss of a single control file, but it does not facilitate point-in-time recovery for data files.

BDuplex the RMAN backup sets.

Duplexing RMAN backup sets creates multiple copies of backups for redundancy, ensuring backup availability, but it does not enable recovery beyond the backup time to the point of failure without archived redo logs.

CMultiplex the online redo log files.

Multiplexing online redo log files protects against loss of an active redo log file, but it does not enable recovery to the point of failure if the database is in NOARCHIVELOG mode, as old log information is eventually overwritten.

DConfigure the database to run in ARCHIVELOG mode.Correct

Configuring the database to run in ARCHIVELOG mode enables the archiving of online redo log files after they are filled. These archived redo logs, in conjunction with a database backup, provide the necessary information to recover the database to any specific point in time, including the moment of failure, by applying all transactional changes recorded in the logs.

Concept tested: Oracle database recovery modes

Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/admin/introduction-to-backup-and-recovery.html#GUID-E1E745A5-BA3E-4B07-B67B-3A47C118B82B

Topics

#ARCHIVELOG mode#Point-in-Time Recovery#Database Recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice