How can I delete old back-ups SAP/Oralce from TSM?

[Former Member]

Hi all,

How can I set an expiration date for old back-ups so that they are deleted when reached that date? For our R/3 Enterprise 4.7 on Oracle 9.2.0.7 / AIX 5.2 we use TSM & Backint.

-

---

BR0278I Command output of '/usr/sap/<SID>/SYS/exe/run/backint

Data Protection for mySAP.com(R) technology

Interface between SAPDBA Utilities and Tivoli Storage Manager

- Version 3, Release 3, Modification 1 for AIX LF 64-bit -

Build: 196 compiled on Feb 24 2003

(c) Copyright IBM Corporation, 1996, 2003, All Rights Reserved.

BKI2027I: Using TSM-API version 5.2.2.0 (compiled with 4.2.3.0).

BKI2000I: Successfully connected to PROLE on port tdpr3ora64.

BKI0005I: Start of program at: Fri Mar 23 20:01:45 2007

[madhukara_shenoy]

Hi,

Not sure whether i understood the requirement correctly. You can set expir_period = < in days> init<sid>.sap

Indicate the period (in days) for which the tapes to be used for the backup should be locked by entering a whole number.

Before BRBACKUP or BRARCHIVE start the backup to a volume, the system checks whether the expiration period set by expir_period for this volume has expired.

If understanding on your question is not correct, please let me know.

[former_member204746]

expir_period will not work when using a SAP agent for backup (backint).

for TSM, you cannot set an expiration date, but you can an expiration based on number of versions.

check http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/com.ibm.itsmerp.doc_5.3.3/fb...

you need to set a value for MAX_VERSIONS in your init[SID].utl file. Then, you init[SID].bki file will keep a count for versionning.

if you use both brbackup and brarchive, I would adive you use mutiple UTL files... and put links to multiple BKI files by adapting parameter CONFIG_FILE in your UTL file.