Re: how to delete old oracle backups at the tsm server

2011-03-22 Thread Nick Laflamme
On Mar 22, 2011, at 1:29 AM, TSM wrote: > Hello, > > We use tdp for oracle with no catalog database. > We set the oracle parameter control_file_record_keep_time too low. > So the "delete obsolete" removed nothing, because oracle removed the > entries earlier from the controlfiles. > > Now we hav

Re: how to delete old oracle backups at the tsm server

2011-03-22 Thread Efim
Hello, Use tdposync for synchronize items in TSM server and RMAN catalog. Check TSM policy for oracle. It mus be set to 0 for verdeleted and retonly, because you can't restore inactive objects from TSM using RMAN. Also check that backdelete set to yes in Oracle node properties. Run expiration. --

Re: how to delete old oracle backups at the tsm server

2011-03-22 Thread Grigori Solonovitch
I am using next script: #!/bin/sh # # Cross-check Recovery Catalog and TSM database # # Input parameters: # 1 - database SID. # export ORACLE_SID=$1 export ORACLE_HOME=`grep "$1:" /etc/oratab | head -n1 | cut -f2 -d":"` export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/adm

Re: how to delete old oracle backups at the tsm server

2011-03-22 Thread Wira Chinwong
Hi, May be need to run "crosscheck backup" and "delete expire" command from RMAN. Best Regards, Wira Chinwong SCSi Co., Ltd. 2521/69 Biztown Ladprao Rd., Klongchaokhunsingha, Wangthonglang, Bangkok 10310 Tel 02-9559873-4 Fax 02-9559875 ext 5 Mobile: 086-9092992 E-mail: w...@scsi.co.t