Re: max databases in one RMAN catalog
Date: Wed, 22 Apr 2009 21:54:57 +1200
wellll - we had 500+ without any real issue ... the occasional database would have issues with things like slow "resync catalog" because of thousands of tablespaces but the rest were fine. ROUT would also have problems with >500k rows, usually because of a monster crosscheck output somewhere but that's not too bad either as you can just truncate it (!!) once you realise Metalink's 'fix' doesn't work for you :P Again, capacity related but not strictly due to number of databases in the catalog.
2009/4/22 Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
> What is the most databases you have registered with a single RMAN catalog?
> I'm familiar with the one database per schema approach (and have
> configured that before) however I'm interested in the ease of reporting
> on multiple database backups from a single schema. The rumor mill here
> at work is suggesting that the RMAN catalog can't handle more than a few
> hundred databases. Can anyone debunk or verify that? Is there anyone out
> there who's got a few thousand databases running nightly backups on a
> single RMAN catalog?
> Jeremy Schneider
> Chicago, IL