TDPO and RMAN deleting backups..once again

[linuxdomination]

hi all,

our rman never expires backups on the tsm server...seen many topics here but i want to ask...

is running "crosscheck backup;" the only way, since "delete noprompt expired backup;" "delete noprompt obsolete;" for themselves has no effect on the tsm server.

very nice because crosscheck is not recomended by oracle, so what to do to avoid bad things to happen?

chris

 

[d.veeresh]

Please check retion periods on TSM Server and Oracle end.

 

[linuxdomination]

rman ->

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

tsm ->

Policy Domain Name: PD_RMAN
Policy Set Name: PS_RMAN
Mgmt Class Name: MC_DEF
Copy Group Name: STANDARD
Copy Group Type: Backup
Versions Data Exists: 1
Versions Data Deleted: 1
Retain Extra Versions: 0
Retain Only Version: 0

 

[d.veeresh]

pls refer the following ,you can delete expire backup.

hi,

run
{
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
CROSSCHECK BACKUP OF DATABASE;
delete noprompt expired backup;
delete noprompt obsolete;
resync catalog;
release channel;
}


and run expire inverty on server end.