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.
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)- A7% (2)
- B4% (1)
- D89% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.