TDP Oracle delete backup very slow

[clafleur]

Hey all,

I'm using TDP Oracle 5.4.1.0 and when i run delete backup command, it's work but very slow.

Anybody have see this before ? Any hints ?

Thanks

 

[ttrinh7975]

clafleur-

Have you try the "del fi" from TSM server?

>>-DELete FIlespace--node_name--file_space_name----------------->

.-Type--=--ANY--------------.
>--+---------------------------+-------------------------------->
more... (<ENTER> to continue, 'C' to cancel)

'-Type--=--+-ANY----------+-'
+-Backup-------+
+-ARchive------+
+-SPacemanaged-+
'-SERver-------'

.-DAta--=--ANY-------------. .-Wait--=--No------.
>--+--------------------------+--+------------------+----------->
'-DAta--=--+-ANY---------+-' '-Wait--=--+-No--+-'
+-FIles-------+ '-Yes-'
| (1) |
'-IMages------'

.-NAMEType--=--SERVER------.
>--+----------------------+--+--------------------------+------->
'-OWNer--=--owner_name-' '-NAMEType--=--+-SERVER--+-'
+-UNIcode-+
'-FSID----'

.-CODEType--=--BOTH-----------.
>--+-----------------------------+-----------------------------><
'-CODEType--=--+-UNIcode----+-'
+-NONUNIcode-+

 

[itguy1984]

How are your Data/Logs Configured Disk Wise?

RAID?

 

[clafleur]

"del fi" from TSM server run well.

For disk configuration, im using ASM Group spanned over multiple lun on SAN. Access, backup and operation run well.

I tryed TDPOconf.exe sync but that not solved my problem.

 

[mccleld]

If you're running 'delete backup' to delete only a subset of your RMAN backuppieces (based upon date/tag etc) then 'delete filespace' from the TSM server might be a little heavy-handed (!).

Never seen this before (although if you have got a lot of historical backups to delete, it can normally take a while from my experience), but I'd be curious as to where the 'wait' was here. Am I right in thinking there are lots of sessions opening and closing between your TDP client and TSM server when running the delete? Is the wait time in between sessions are opening and closing, or whilst a session is open on your TSM server? Does a 'list backup;' give you an idea of how many backup objects you're trying to delete?

 

[clafleur]

using output from list backup, ill try to delete one backup (not all expired) ... and its take a while to get success deletion. :|