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
|