1Z0-063 · Question #230
You use RMAN to take regular backups for your database. Examine the RMAN commands: RMAN> CROSSCHECK BACKUP; RMAN>DELETE EXPITED BACKUP; Which statement is true?
The correct answer is B. All metadata, for backups and archived redo log files that are recorded in the repository but do not. See the full explanation below for the reasoning.
Question
Options
- AAll backups and archived redo log files that are not required for the recovery are deleted and the
- BAll metadata, for backups and archived redo log files that are recorded in the repository but do not
- CAll backups that have exceeded the age set by the RMAN retention policy are deleted.
- DAll metadata pertaining to backups and archived redo log files that have exceeded the age set by
How the community answered
(38 responses)- A8% (3)
- B71% (27)
- C16% (6)
- D5% (2)
Community Discussion
5The answer is B, and the reason comes down to understanding what EXPIRED actually means in RMAN's world. CROSSCHECK BACKUP does not delete anything, it just goes out to disk or tape and verifies whether each backup piece recorded in the repository actually exists at its expected location, and anything it cannot find gets stamped EXPIRED in the repository. DELETE EXPIRED BACKUP then removes those repository records for pieces RMAN could not locate physically, which means there are no actual files being deleted because the files were already gone before you ran either command. People confuse EXPIRED with OBSOLETE all the time on this exam: OBSOLETE means a backup still exists but falls outside your retention policy, while EXPIRED means the repository says it should be there but it physically is not. Options A, C, and D describe behavior that belongs to DELETE OBSOLETE, not DELETE EXPIRED BACKUP.
I'll be honest, I almost clicked C because "expired" sounds like it has to do with age or retention, which tripped me up. But then I remembered that CROSSCHECK just syncs the repository against what physically exists on disk or tape, and DELETE EXPIRED only removes the catalog metadata for backups that CROSSCHECK marked as missing, not anything related to retention policy age.
I picked D first because it said "metadata" which felt right, then I caught the phrase "exceeded the age set by" and realized that describes OBSOLETE backups, not EXPIRED ones. EXPIRED means CROSSCHECK could not physically find the backup piece, so DELETE EXPIRED BACKUP just cleans the repository record for something already missing, which is exactly what B says.
Has to be D, because CROSSCHECK just syncs the repository against what physically exists on disk or tape, it does not delete anything based on recoverability, so DELETE EXPIRED BACKUP then only removes the metadata for records that RMAN marked expired, which ties directly to age via the retention policy, not to whether a file is needed for recovery.
Carlos, the key is that EXPIRED and OBSOLETE mean two different things in RMAN: EXPIRED means the file could not be found on disk or tape after CROSSCHECK runs, while OBSOLETE means the backup is no longer needed to meet the retention policy, so DELETE OBSOLETE is what actually removes backups based on recoverability, which makes B correct. DELETE EXPIRED BACKUP only cleans up catalog records for files that are already physically missing, not for files that fall outside the retention window.