Oracle Database 12c: Installation and Administration — Question 170

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? (Choose three.)

Answer options

• A. The backup sets marked as expired are deleted.
• B. The information related to the backups is removed from the recovery catalog and the control file.
• C. The physical files related to the backup need to be manually deleted.
• D. The physical files related to the backup are deleted automatically.
• E. The backups deleted are based on the backup retention policy.

Correct answer: B, D, E

Explanation

Option B is correct because executing DELETE OBSOLETE removes backup information from both the recovery catalog and control file. Option D is also correct as the command deletes the physical backup files automatically, while option E is right since the deletions adhere to the defined backup retention policy. Options A and C are incorrect because expired backups are not deleted by this command, and manual intervention is not required for the physical files.