Oracle-L: RE: RMAN Catalog: 1 vs. many

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Fri, 04 Apr 2003 20:38:56 -0800
Message-ID: <F001.0057B346.20030404203856@fatcity.com>

Gaja:

Having dedicated RMAN server is indeed a good idea, but RMAN catalog is not designed for that much (!!?) high concurrency. If you look at the commands (executed by the RMAN during backup) very closely, you will see lots of SELECT for UPDATE and this will cause a big bottleneck in the backup process.

It happened at one of our client place where they backup 200+ databases with a single RMAN catalog at 2-3 hrs interval. The workaround suggested was a) Have more RMAN Catalogs
b) Run the backup in different times.

So again it 'all depends '

Best Regards,
K Gopalakrishnan

-----Original Message-----
Krishna Vaidyanatha
Sent: Friday, April 04, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L

Paul et al.,

I agree with Paul's setup of a dedicated RMAN catalog server. It is not a bad idea to have the datafiles for this database on mirrored volumes. I also think a good practice related to "saving the catalog" against tape media errors is to do a full export on the RMAN Catalog DB and stash the export dumpfile away on a mirrored volume away from the datafiles.

If this DB has nothing but the RMAN catalog, it should not be very large (let me know if this is otherwise) and thus the full export will be a good method to have a "logical backup". One more thing to save the skin on your back, at a time of need. When Murphy is around I think the word "mercy" vanishes from the English dictionary.

Cheers,

Gaja

Paula_Stankus_at_doh.state.fl.us wrote:
> I have setup a server for just rman catalog backed
> up to tape with clones
> offsite for DR. It makes it easier as scripts are
> parameterized to keep
> aware of backup statuses = etc. Having this on a
> centralized management
> server and can't believe this isn't just common
> practice. Just make sure no
> single point of failure.
>
> Oracle OCP DBA
>
>
> -----Original Message-----
> Sent: Friday, April 04, 2003 3:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Deepak
> You may also wish to consider not using
> catalog(s) -- control file
> backups. This might make it easier to add and remove
> databases in your
> environment. I'm presuming most databases are on
> their own server.
> If you want to be able to run a single query that
> will report any backup
> problems across all your databases, you will use a
> single catalog.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Friday, April 04, 2003 2:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> We are in the process of moving from traditional hot
> backups to one using RMAN. Total databases are
> around
> 200+. Should we be using 1 or few RMAN catalogs, or
> 1
> catalog per database?
>
> Thanks,
> Deepak
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms,
> and more
> http://tax.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Deepak Sharma
> INET: sharmakdeep_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: oraperfman_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Apr 04 2003 - 22:38:56 CST

RE: RMAN Catalog: 1 vs. many - Opinions