nerdexam
Oracle

1Z0-062 · Question #341

Which statement is true about a database in ARCHIVELOG mode?

The correct answer is D. Full database backups can be performed when the database is opened. This question asks for a true statement regarding a database configured in ARCHIVELOG mode. In ARCHIVELOG mode, full database backups can be taken while the database is open and available for transactions.

Performing Backup and Recovery

Question

Which statement is true about a database in ARCHIVELOG mode?

Options

  • AAll backups taken prior to switching to ARCHIVELOG mode can be used to perform complete
  • BOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG
  • CA Fast Recovery Area (FRA) must be configured for the database.
  • DFull database backups can be performed when the database is opened.

How the community answered

(39 responses)
  • A
    8% (3)
  • B
    3% (1)
  • C
    3% (1)
  • D
    87% (34)

Why each option

This question asks for a true statement regarding a database configured in ARCHIVELOG mode. In ARCHIVELOG mode, full database backups can be taken while the database is open and available for transactions.

AAll backups taken prior to switching to ARCHIVELOG mode can be used to perform complete

Backups taken prior to switching to ARCHIVELOG mode (i.e., in NOARCHIVELOG mode) cannot be used for point-in-time recovery to an arbitrary point using archived logs, only for complete recovery up to the backup time.

BOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG

While multiplexing online redo log files is a best practice for redundancy, it is not a mandatory prerequisite for enabling ARCHIVELOG mode.

CA Fast Recovery Area (FRA) must be configured for the database.

A Fast Recovery Area (FRA) is a recommended configuration for managing recovery-related files, but it is not strictly mandatory for a database to operate in ARCHIVELOG mode.

DFull database backups can be performed when the database is opened.Correct

When a database is in ARCHIVELOG mode, it is possible to perform online (hot) backups of the entire database, meaning the database can remain open and active during the backup process. This is because ARCHIVELOG mode ensures that all changes are captured in archived redo logs, allowing for consistent recovery from an online backup.

Concept tested: ARCHIVELOG mode characteristics

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-archived-redo-logs.html#GUID-829D00D0-7460-4927-A253-5353AF9E45E8

Topics

#ARCHIVELOG mode#database backup#online backup

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice