>From my experience with RMAN and Oracle I would recommend to create a
separate database specifically for the rman recovery catalog. Oracle has
good documentation on best practices and how to setup rman, but you need to
have an Oracle metalink account. If you have a separate database created
for the recovery catalog, then you enable the ability to shut it down to
perform cold backups of the recovery database without affecting a production
database. Also, if you have the recovery catalog tables, etc. stored in an
existing database, then that recovery catalog cannot be used to backup that
database. This is another reason for a separate database for the recovery
catalog.
Another thing that you have to be careful with when working with Oracle RMAN
is to make sure you are keenly aware of the Oracle rman support matrix.
Certain versions of Oracle require specific versions of rman. Some day
Oracle will be a little more backward compatible with their rman product,
but currently that is not the case.
So far as where to put this rman database, I would suggest on one of the
servers that already has Oracle running. That way you do not have to
install Oracle binaries on another server for the sole purpose of a recovery
catalog which may only require a database the size of 100MB or so. (This of
course is an initial size, and could grow, but I still consider a 100MB
database tiny.)
So far as Vericon, maybe I will have to check to see if there is still time
to submit papers. :-) I have experience implementing a Oracle rman and
NetBackup solution in which we took the backup time down from 17 hours to 51
minutes. This was going from a hot backup solution to a rman / netbackup
solution. The benefit of rman is that it doesn't backup "white space" and
with NetBackup I was able to multistream the jobs across 8 tape drives.
Dan Sixbury
Celeritas Technologies, LLC
913-491-9000
-----Original Message-----
From: Dennis Dwyer [mailto:dfdwyer AT tecoenergy DOT com]
Sent: Friday, August 31, 2001 10:16 AM
To: Penelope.Carr AT veritas DOT com
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Additional Comments of NBU DB Extension for Oracle
Penelope,
I read with great interest your note on using the Recovery Catalogue when
building the backup environment for clients with the Oracle DB Extension and
RMAN. I also noted another participant's mail on the time required to
restore with and without the catalogue so it seems that the catalogue is the
smart way to go. I am not an Oracle person by any stretch of the imagination
so I'm trying to figure out where exactly to create this catalogue. The
assumption is wherever I put it, Oracle has to be installed there. That
leaves out my NetBackup servers because I doubt that I'll be able to justify
the license. Putting it with other databases that already exist on other
servers has drawn a bit of criticism from the Oracle folks here. I'm
assuming that the server I'm backing up could also host the recovery
catalogue but are there any performance implications associated with that?
I've seen where I only need one catalogue to service all Oracle backups I
may do on any server but since we!
usually build a server for each application (no E10K's here) I suspect
that no one server owner will want to be the host for all other potential
servers. I guess you can't have multiple Recovery Catalogues can you?
Any other additional guidance you can give on this subject would be greatly
appreciated. I'm still trying to figure out where to head with this and I
don't find the supporting documentation that I have all that great. You
mentioned in a previous note all the good docs that were available. What are
they and where can I find them?
I can probably speak for the whole list when I say we appreciate your help
and experience on this. This would probably be a great tech topic at Vericon
2001. I know I'd sit through it twice.
Regards,
Dennis
Quote: "Time is not a test of the truth"
Translation: Just because you've always done it that way, doesn't make it
right
Dennis F. Dwyer
Enterprise Storage Manager
Tampa Electric Company
(813) 225-5181 - Voice
(813) 275-3599 - FAX
Visit our corporate website at www.tecoenergy.com
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
