1Z0-062 · Question #259
You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command: RMAN> DELETE OBSOLETE; Which three statements are true is…
The correct answer is B. The information related to the backups is removed from the recovery catalog and the control file. D. The physical files related to the backup are deleted automatically. E. The backups deleted are based on the backup retention policy. The RMAN DELETE OBSOLETE command is used to automatically remove backups that are no longer needed according to the configured retention policy, simultaneously deleting both the physical backup files and their corresponding metadata.
Question
You perform RMAN backups for your database and use a recovery catalog for managing the backups. To free space, you execute this command:
RMAN> DELETE OBSOLETE; Which three statements are true is this scenario?
Options
- AA backup sets markedas expired are deleted.
- BThe information related to the backups is removed from the recovery catalog and the control file.
- CThe physical files related to the backup need to be manually deleted.
- DThe physical files related to the backup are deleted automatically.
- EThe backups deleted are based on the backup retention policy.
How the community answered
(40 responses)- A18% (7)
- B75% (30)
- C8% (3)
Why each option
The RMAN DELETE OBSOLETE command is used to automatically remove backups that are no longer needed according to the configured retention policy, simultaneously deleting both the physical backup files and their corresponding metadata.
`DELETE OBSOLETE` removes backups based on the retention policy, not backups specifically marked as expired, which are handled by `CROSSCHECK` and `DELETE EXPIRED` commands.
When `DELETE OBSOLETE` is executed, RMAN updates its repository by removing the metadata about the deleted backups from both the recovery catalog (if used) and the database control file.
RMAN automates the deletion of physical backup files for obsolete backups; manual deletion is not required and would lead to repository inconsistencies.
The `DELETE OBSOLETE` command automatically performs the physical deletion of obsolete backup pieces and backup sets from their storage locations, without requiring manual intervention.
The determination of which backups are obsolete and eligible for deletion is based on the currently configured RMAN backup retention policy, which specifies the criteria for keeping or discarding backups.
Concept tested: RMAN DELETE OBSOLETE and retention policy
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-and-recovering-with-rman.html#GUID-E373F605-CF74-4C2E-862C-09559F45991A
Topics
Community Discussion
No community discussion yet for this question.