How to delete expired archive logs in oracle

Many novices are not very clear about how to delete expired archive logs in oracle. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

1. The generation of EXPIRED state is closely related to the crosscheck command relative to whether the OS file exists or not. RMAN uses the crosscheck command.

Check if the backup exists on the backup media, and if not, change the status from AVAILABLE to EXPIRED. Can be used

Delete (noprompt) expired backup ofcontrolfile to delete backup information of expired in catalog

2. For obsolete status, relative to backup policy, it is for MAN backup retention policy. Backups that exceed this retention policy will be marked as obsolete, but their status is still AVAILABLE. We can use report obsolete to view abandoned backups.

A backup of. You can use the delete noprompt obsolete command (noprompt means you don't need to be sure

Recognize): RMAN > delete noprompt obsolete

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.