nerdexam
Oracle

1Z0-062 · Question #240

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario?

The correct answer is A. The user-managed backup consists of only formatted data blocks. D. The RMAN backup can be performed while the database is open.. In ARCHIVELOG mode, RMAN can perform consistent whole database backups while the database is open, and user-managed backups consist of formatted data blocks.

Performing Backup and Recovery

Question

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario?

Options

  • AThe user-managed backup consists of only formatted data blocks.
  • BThe database must be shut down to take a user-managed backup.
  • CThe RMAN backup contains only data files.
  • DThe RMAN backup can be performed while the database is open.
  • EThe database must be in MOUNT state to take RMAN backup.

How the community answered

(19 responses)
  • A
    89% (17)
  • B
    5% (1)
  • E
    5% (1)

Why each option

In ARCHIVELOG mode, RMAN can perform consistent whole database backups while the database is open, and user-managed backups consist of formatted data blocks.

AThe user-managed backup consists of only formatted data blocks.Correct

A user-managed backup, specifically a consistent backup, involves copying data files which primarily contain formatted data blocks and metadata, typically distinct from redo logs or control files unless explicitly copied.

BThe database must be shut down to take a user-managed backup.

For a consistent user-managed backup in ARCHIVELOG mode, the database must be in MOUNT state or SHUTDOWN (CLOSED) state to guarantee consistency, but it's not strictly required to be shut down if using RMAN hot backup.

CThe RMAN backup contains only data files.

An RMAN backup of the whole database typically includes data files, control files, and server parameter files (SPFILE), not just data files.

DThe RMAN backup can be performed while the database is open.Correct

In ARCHIVELOG mode, Oracle's Recovery Manager (RMAN) can perform hot backups (consistent backups) while the database is open and users are actively using it, ensuring data integrity through archived redo logs.

EThe database must be in MOUNT state to take RMAN backup.

While RMAN can perform backups in MOUNT state, it can also perform consistent backups in ARCHIVELOG mode when the database is OPEN, which is a more common and flexible approach.

Concept tested: Oracle RMAN and user-managed backup

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-whole-database.html#GUID-47704739-1E14-4198-8547-06399042295E

Topics

#consistent backup#ARCHIVELOG mode#RMAN backup#user-managed backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice