1Z0-052 · Question #226
In which two cases would you perform only consistent backup? (Choose two.)
The correct answer is B. You are working on a database where downtime can be tolerated. D. You are working on a database that operates in NOARCHIVELOG mode. A consistent (cold) backup requires the database to be shut down cleanly, making it the only viable strategy when downtime is acceptable or when the database runs in NOARCHIVELOG mode.
Question
In which two cases would you perform only consistent backup? (Choose two.)
Options
- AYou are working on a database where downtime is not tolerated.
- BYou are working on a database where downtime can be tolerated.
- CYou are working on a database that operates in ARCHIVELOG mode.
- DYou are working on a database that operates in NOARCHIVELOG mode.
- EYou are working on a database where all the tablespaces are locally managed.
- FYou are working on a database where control files and redo log files are multiplexed.
- GYou are working on a database where control files and redo log files are not multiplexed.
How the community answered
(26 responses)- A4% (1)
- B92% (24)
- E4% (1)
Why each option
A consistent (cold) backup requires the database to be shut down cleanly, making it the only viable strategy when downtime is acceptable or when the database runs in NOARCHIVELOG mode.
When downtime is not tolerated, you must use online (inconsistent) backups, which require ARCHIVELOG mode to apply redo logs during recovery.
A consistent backup requires shutting down the database cleanly so all datafiles, control files, and redo logs are synchronized - this is only feasible when downtime can be tolerated.
ARCHIVELOG mode enables online inconsistent backups with redo application; it does not restrict you to consistent-only backups.
In NOARCHIVELOG mode, archived redo logs are not retained, so Oracle cannot apply redo to bring an inconsistent (online/hot) backup to a consistent state during recovery. A consistent cold backup is therefore the only type that guarantees a restorable copy.
Locally managed tablespaces relate to space management inside the database and have no bearing on whether consistent or inconsistent backups are required.
Multiplexed control files and redo logs improve redundancy but do not dictate the type of backup strategy required.
Non-multiplexed control and redo files increase risk but do not by themselves mandate consistent-only backups.
Concept tested: Consistent vs inconsistent Oracle RMAN backup and NOARCHIVELOG mode requirements
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/making-database-backups.html
Topics
Community Discussion
No community discussion yet for this question.