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.
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)- A89% (17)
- B5% (1)
- E5% (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.
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.
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.
An RMAN backup of the whole database typically includes data files, control files, and server parameter files (SPFILE), not just data files.
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.
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
Community Discussion
No community discussion yet for this question.