RE: RMAN SCHEMAs
Date: Thu, 26 Jun 2008 17:29:09 -0400
See Eric Grancher's comments in my blog before trying to use 11g catalog w/ 10.2.0 target database. http://markjbobak.wordpress.com/2008/06/09/11g-is-more-deadlock-sensitive-than-10g/#comment-6
Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry - lwolfs
Sent: Thursday, June 26, 2008 5:16 PM
Subject: RMAN SCHEMAs
I was wondering what advice you had on limiting and organizing DBs into different RMAN schemas. We've got a client with lots of DBs, who wants to move more to RMAN.
Unfortunately not everyone is proficient in RMAN to start with (I got elevated to #2 in proficiency, but don't be excited about that) And we've had several cases where a DB was cloned and the DBID wasn't changed. So I got to fix the Incarnations.
We've also had problems where a DB was upgraded to 10G but the schema wasn't etc., etc.
We've got 3 different RMAN catalog databases. All 220.127.116.11-6 Some have schemas with as many as 30 DBs being maintained. The DBs range from 8.1.6 to 10.2.0.3
We've had a number of performance issues and earlier someone had split all the SAP DBs into their own. There's at least a dozen of those. The other schemas are generally divided into specific releases and prod/dev/test.
I've been thinking about not using catalogs for the dev & test DBs and just sticking with the control files.
We want to create another RMAN DB and I thought we might as well go to 11G, but everyone is very leery about that. I did like the new import feature in 11G.
Suggestions and warnings welcome.
Do have a copy of Note: 247611.1 Known RMAN Performance Problems
TIA Larry Wolfson
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
http://www.freelists.org/webpage/oracle-l Received on Thu Jun 26 2008 - 16:29:09 CDT