RMAN Commands

Delete from TSM 

tdpo syncDB

List backup before 45 days

list backup completed before “sysdate-45”;

List of obsolete backup

report obsolete;

script to do crosscheck and delete obsolete

RUN
{
crosscheck copy of controlfile;
delete noprompt obsolete;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
crosscheck archivelog all;
delete noprompt expired archivelog all;
}

script to delete for orphan backup from catalog

list backup;
run
{
set dbid=2874538101;
delete noprompt backup;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
crosscheck archivelog all;
}