nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • A
    4% (1)
  • B
    92% (24)
  • E
    4% (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.

AYou are working on a database where downtime is not tolerated.

When downtime is not tolerated, you must use online (inconsistent) backups, which require ARCHIVELOG mode to apply redo logs during recovery.

BYou are working on a database where downtime can be tolerated.Correct

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.

CYou are working on a database that operates in ARCHIVELOG mode.

ARCHIVELOG mode enables online inconsistent backups with redo application; it does not restrict you to consistent-only backups.

DYou are working on a database that operates in NOARCHIVELOG mode.Correct

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.

EYou are working on a database where all the tablespaces are locally managed.

Locally managed tablespaces relate to space management inside the database and have no bearing on whether consistent or inconsistent backups are required.

FYou are working on a database where control files and redo log files are multiplexed.

Multiplexed control files and redo logs improve redundancy but do not dictate the type of backup strategy required.

GYou are working on a database where control files and redo log files are not multiplexed.

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

#consistent backup#NOARCHIVELOG mode#backup types#database downtime

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice