You can use the TDPO utility tdposync to get rid of backups in TSM that RMAN
no longer knows.
"The tdposync utility checks for items on the Tivoli Storage Manager server
that are not in the RMAN catalog. This utility allows you to repair such
discrepancies between the Tivoli Storage Manager server and the RMAN catalog.
By thus removing unwanted objects in Tivoli Storage Manager storage, you can
reclaim space on the server."
HTH
Thomas Rupp
-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag
von Seay, Lisa
Gesendet: Montag, 13. August 2007 17:14
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] TDP for Oracle question.
"What is more fun is when the RMAN catalogue has been
deleted and the DAB cannot gracefully purge the backups so you have to
manually delete the objects in TSM."
Rich, I am a new TSM admin and I was just asked to research how to do this.
Our Oracle dba said he knows he orphaned a large amount of backups and needs
me to use TSM to get to them to delete them.
Please, please, please share your knowledge with me! My tapes are being
eaten up by these useless gigs of data.
Thank you,
Lisa Seay <mailto:seayl AT flalottery DOT com>
Technical Analyst I
SWATd Systems Support (Storage, WebSphere, AIX Tivoli, database)
Florida Lottery
850/487-7777 ext. 2059
Join the Global Tivoli Community -
www.Tivoli-ug.org
PLEASE NOTE: Florida has a very broad public records law. Most written
communications to or from state officials regarding state business are
considered to be public records and will be made available to the public and
the media upon request. Your e-mail messages may, therefore, be subject to
public disclosure.
-----Original Message-----
From: Richard Mochnaczewski
[mailto:Richard.Mochnaczewski AT STANDARDLIFE DOT CA]
Sent: Friday, August 03, 2007 2:45 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] TDP for Oracle question.
RMAN backups using different storage pool
1) Verify the TDPO_FS entry in the tdpo.opt file. The standard entry is
called adsm-rman. This is a "virtual" filesystem used by RMAN. It doesn't
exist physically on the client system, but if I run a query filespace on a
node in TSM that is using RMAN, this filesystem is listed.
2) Create a management class called RMAN pointing to the desired storage
pool.
3) Create a new include-exclude entry ( or file if it doesn;t exist ) with
the following entry :
include /adsm-rman/.../* RMAN
This entry tells TDP to point the backup ( /adsm-rman ) to the RMAN
management class .
4) Modify the RMAN stanza portion of the dsm.sys to point to the newly
created include-exclude file.
5) Run the backup and see if it uses the storage pool by doing a q vol on
the voluems in the storage pool. The rman files usually begin with df_.
NOTE: RMAN uses its own expiration mechanism. Youo have tio keep on top of
the DBAs in order to make sure they are expiring their backups properly or
you could end up with terabytes of old backups ( been there done that ).
What is more fun is when the RMAN catalogue has been deleted and the DAB
cannot gracefully purge the backups so you have to manually delete the
objects in TSM .
Let me know if you have any other questions.
Rich
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Ben Bullock
Sent: Friday, August 03, 2007 2:39 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP for Oracle question.
I have a question about the TDP for Oracle product.
Is there a way to have the RMAN command bind the oracle backups
to a specific management class (so it can go to a different
storagepool)? To this point we have a separate domain for the TDP
clients and only have the 1 required default management class that all
clients use.
We now would like a subset of the TDP clients to go to a
different storagepool for higher availability. At this point I am
thinking I might have to just create another domain with a MC that
points to this other storagepool and then move the TDP client to the new
domain to pick up the new location.
Yea? Nay? It's Friday, who cares, I'm outa here is X hours? ;-)
Ben
Vorarlberger Illwerke AG ein Unternehmen von illwerke vkw
Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN 59202 m,
Firmenbuchgericht: LG Feldkirch, UID-Nr.: ATU 36737402
|
