You have noticed that you are left with some old backups which are no longer required. You have been using RMAN and now you want to have a list of these files. Which Recovery Manager task will accomplish this?
-
LIST NEED BACKUP;
-
REPORT EXPIRED BACKUPS;
-
REPORT OBSOLETE;
-
LIST OBSOLETE BACKUPS;
C
Correct answer
Explanation
The correct answer is C because REPORT OBSOLETE is the correct RMAN command to list backups that are no longer needed based on the retention policy. Option A (LIST NEED BACKUP) is not a valid RMAN command. Option B (REPORT EXPIRED BACKUPS) refers to backups that have exceeded their retention period, not those that are simply no longer needed. Option D (LIST OBSOLETE BACKUPS) is not the correct syntax.