Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

What does RMAN command delete noprompt obsolete,delete?

Shulou Source: shulou.com Published: 2022-06-03 05:04:26 10月03日 Update

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

Tags: Backup commands scripts labs logs policies now processing deadline Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei Linux MySQL Shulou Tech Info vpn