Re: max databases in one RMAN catalog
- From: "~Jeff~" <jifjif@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, jeremy.schneider@xxxxxxxxxxxxxx
- Date: Wed, 22 Apr 2009 21:54:57 +1200
hi Jeremy
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.
.
HTH,
Jeff Wong
.
2009/4/22 Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
> 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
>
>
> --
> Jeremy Schneider
> Chicago, IL
> http://www.ardentperf.com
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
