Dear All,

I am doing testing on RMAN/ConnectAgent for Oracle.

To speed up restore, I use multiple ADSM nodename for the backup. As a
result, corresponding ADSM nodename in 'allocate channel' has to be matched
with backup_piece name in backup/restore and 'change backuppiece ...
delete' for expiration.

I ran an expiration, due to typo-error, the 'change backuppiece ... delete'
was issued against a 'allocate channel for delete' with a wrong ADSM
nodename, error message displayed in sbtio.log & delete failed:

(445) OBK-sbt:<10/05/1998:13:49:11> queryObj():  ANS1302E (RC2)    No
objects on server match query

(445) OBK-sbt:<10/05/1998:13:49:11> sbtremove():  ANS1302E (RC2)    No
objects on server match query

(445) OBK-sbt:<10/05/1998:13:49:11> sbtremove(): oer = 7080, errno = 2.

(445) OBK-sbt:<10/05/1998:13:49:11> sbtremove():  ANS1302E (RC2)    No
objects on server match query

However, RMAN considers the backuppiece is already deleted (from RMAN 'list
backupset' or rc_backup_piece of recovery catalog) so I cannot run the
'change backuppiece ... delete' again.

Question:
How can I delete those expired objects from ADSM? Can I do it with a
self-developed API program? If so, is there a sample as I know nothing
about API.  I cannot run "delete filespace" as not all the backup under
that filespace & nodename are to be expired.  I anticipate this will happen
to me again, your help will be greatly appreciated. Thank you.

Regards,
Eric Tang / Hong Kong / IBM  @ IBMHK
Technical Services, Strategic Outsourcing,
IBM Greater China Group
Tel: (852)-2105-2119,   Fax: (852)-2861-2493
Notes: Eric KF Tang/Hong Kong/IBM@IBMHK
Internet : tangeric@ hk1.ibm.com