Shulou(Shulou.com)06/03 Report--

Use "delete noprompt obsolete;" in the RMAN script to delete backups that exceed the save policy.

In the past, my backup script used to deal with archived logs with "plus archivelog delete all input". After backing up the archivelog, I deleted it immediately. I always thought that "delete noprompt obsolete;" only deleted the backup set but not the archive.

Today, in the DataGuard experiment, Primary needs to save the most recent archivelog so that it can be picked up when the archivelog gap appears in standby.

It was found in the experiment that it would also delete the archivelog related to obsolete backupset.

All dataguard cannot be deleted with the command delete noprompt obsolete;.

What command does it take to delete it?

Delete archivelog until time 'sysdate-7'; delete all archivelog as of the first 7 days

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.