Skip to content

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;
}

 

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: