Oracle Database Discussions

Hi,

DB: 10.2.0.4 RAC ASM
OS: AIX 5.3 L 64-bit

I have FRA disk and tape daily backups for my live database. I have 3 as retention policy.I do not have any catalog database.

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/10.2.0.1/db_1
/dbs/snapcf_gcprod1.f'; # default

As per the retention policy , the database backup on FRA is there for last 3 days.This everything is fine.

If i look my tape backup contents , it has 6 months old backup also.
I want to delete all old backups from tape and need only last 1 month backup .How do i can do this?.

If i allocate tape channel and run delete obsolete , will it delete all backup pieces from tape except last 3 days , as per retention policy?.If yes, then it will be problem for us.

I did not specify any delete obsolete query in my tape backup script , given crosscheck only.

Am i ok with below steps ,

run
{
allocate channel c1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
crosscheck backup;
delete noprompt obsolete ;
crosscheck archivelog all;
delete noprompt expired archivelog all;
}

Please suggest me how can i delete old backup files from tape.Tivoli guys are saying that tape backup contents have to be deleted from RMAN only.Shall i have to provide any additional details?.

Thanks,
Sunand