Hi Cynthia -
To my knowledge of working with RMAN and TSM, your DBA is incorrect. The
repository should not reside on the TSM server. It would utilize resources
that would slow down the TSM server as well as the Oracle backup.
We run TDP for Oracle on 8 Unix servers and the Oracle repository resides on
the server that it came from <in other words, the client>. We have separate
filesystems that house it and then Rman does its thing. The only thing that
we have on the TSM server side is the data itself that was backed up and the
information in the database that TSM needs to locate for a restore from
RMAN. All backup and expirations are done through RMAN and in my knowledge
of RMAN, there is no need to store the repository on the TSM server.
Honestly, if our DBA's asked us to do this, our response would be no.
The TSM server should be used specifically for housing TSM pertinent data
and not Oracle repositories clogging it up. After all, what is the point in
having a separate server for Oracle?
In addition, I would think that it would mean more network traffic as Rman
needs to talk with this data every time it connects to the server to tell
what it needs to backup and what it needs to expire.
-----Original Message-----
From: CANNAM, CYNTHIA L (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 14, 2000 11:29 AM
To: [EMAIL PROTECTED]
Subject: oracle tdp/rman/rman repository issues
To all:
Environment: AIX 4.3.3
TSM server 3.7.3
Oracle TDP 3.7.1
Oracle 8.1.5/6
TSM client V3.7.2 on AIX 4.3.3
We've been trying to get some historical data (if any is available) for the
impact an Oracle repository will have on TSM if the repository will reside
ON the TSM server. One of our DBAs is telling us that RMAN requires a
central repository (which is comprised of 36 GBs of disk housing Oracle
binaries, oraarch, oradata, and DBA home directories) that should reside on
our AIX TSM server.
We have numerous issues (all of which we have voiced loudly) with this piece
of Oracle residing on our TSM server, but in absence of hard data stating
that this move is a disaster waiting to happen, we're powerless to stop its
going forward. The edict from management is: let the Oracle people have
their way.
Is anyone out there using the Oracle TDP with AIX (or other platforms) going
to an AIX TSM server where this RMAN repository physically resides on the
TSM server itself? Would you be willing to share your experiences, good or
bad, with us, to help us make a case for keeping this repository from
residing on the TSM server? Gut feeling and experience with the TSM
environment are not enough on which to base a final decision.
Thanks much!
Cindy Cannam
Cynthia L. (Cindy) Cannam, MBA
Enterprise Storage Management
TSM/ADSM Technical Support
SBC Services, Inc.
(314)340-0722 office
(888)476-0998 pager
(314)340-0992 fax
Nearly Native Floridian
Freezing in the Midwest
This e-mail and any files transmitted with it are the property of SBC, are
confidential, and are intended solely for the use of the individual or
entity to whom this e-mail is addressed. If you are not one of the named
recipient(s) or otherwise have reason to believe that you have received this
message in error, please notify the sender at (314)340-0722 and delete this
message immediately from your computer. Any other use, retention,
dissemination, forwarding, printing, or copying of this e-mail is strictly
prohibited."
