1Z0-062 · Question #306
You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters: Which two statements are true about a whole consistent backup of a da
The correct answer is B. The database instance must be shut down to take the backup. E. The system Change Number (SCN) is the same for all the data files in the backup.. A whole consistent backup in ARCHIVELOG mode requires the database instance to be shut down cleanly to ensure all data files reflect the same System Change Number (SCN).
Question
You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters:
Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)
Exhibit
Options
- AThe backup can be used as an incremental level 0 backup.
- BThe database instance must be shut down to take the backup.
- CThe database must be in MOUNT state to take the backup.
- DThe backup consists of blocks that have been formatted.
- EThe system Change Number (SCN) is the same for all the data files in the backup.
How the community answered
(42 responses)- A12% (5)
- B81% (34)
- C2% (1)
- D5% (2)
Why each option
A whole consistent backup in ARCHIVELOG mode requires the database instance to be shut down cleanly to ensure all data files reflect the same System Change Number (SCN).
While a whole consistent backup can logically serve as a base for subsequent incremental backups, stating it 'can be used as an incremental level 0 backup' does not fully capture its defining characteristic regarding consistency.
A whole consistent backup requires the database to be shut down cleanly (e.g., using SHUTDOWN NORMAL, IMMEDIATE, or TRANSACTIONAL) before the backup begins, ensuring a consistent state at the time of backup.
The database must be in a 'closed' or 'shut down' state for a consistent backup, though RMAN typically operates with the database in the MOUNT state to access control file information.
All RMAN backups generally consist of blocks that have been formatted and contain data, but this is a general characteristic of RMAN backups, not a specific defining truth unique to a whole consistent backup.
For a consistent backup, all data files are written to disk at the same logical point in time, meaning they all share an identical System Change Number (SCN) which represents this consistent state.
Concept tested: RMAN consistent backup and database states
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-backup-types.html#GUID-BC320078-E169-42F3-9D09-2166F5310F0B
Topics
Community Discussion
No community discussion yet for this question.
