Re: RMAN Configuration Question

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Tue, 05 Mar 2002 10:33:26 -0800
Message-ID: <F001.0041FD15.20020305103326@fatcity.com>

Hi Pat,

to cut to the chase here is how we do it in our shop ..

we have :
1. East Coast: we have bunch of DB's & 1 tape server 2. West Coast: we have bunch of DB's & 1 tape server

Rman Strategy:
We have two catalogs, one which caters to all db's on east coast and backs ups db's on east coast tape server.

The other catalog caters to backups for all db's on west coast and backs up to west coast tape server

Catalog backup (next step)

      --> East coast catalog db is registered in west coast catalog and is backed up daily. So in case the east coast catalog Database goes down, we can use the west coast catalog to restore it!! And viceversa for west coast which is registered to the east coast

Note: keeping the catalog on differnt independent hardware prevents single point of failure of prod and catalog

Dev Databases: We dont care and just use exp/imp

hth
Deepak

• Pat Howe <phowe_at_Illuminet.com> wrote:
  > I have just completed Oracle Education's "Enterprise
  > DBA Part 1B: Backup and
  > Recover" course.
  > Page 11-5 states : It is recommended that you have a
  > separate catalog for
  > each database.
  >
  > My question is :
  > Why? Does this help you cleanup the RMAN catalog
  > if you ever drop a
  > database (you can drop the schema owner)?
  > Is this how others have configured their RMAN
  > database ?
  >
  > Thus I am seeing 2 Configuration Models ;
  > Have one schema owner per database that you are
  > backing up.
  > If you had two databases "PROD and DEV" then setup a
  > RMAN-PROD and an
  > RMAN-DEV schema owner (different RMAN Catalogs) in
  > the same RMAN tablespace
  > to manage each database's recovery info.
  > VERSES
  > Have one schema owner (catalog) for all the
  > databases that you are backing
  > up.
  > If you had two databases "PROD and DEV" then setup
  > one schema owner RMAN
  > (one RMAN Catalog) in the RMAN tablespace to manage
  > all database recovery
  > info.
  >
  > What are the pro's and con's?
  >
  > Thanks in Advance
  > _________________________
  > Patrick J. Howe
  > Oracle DBA
  > Illuminet Inc. (Carrier Division of Verisign)
  > 4501 Intelco Loop SE
  > Email : phowe_at_illuminet.com
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Pat Howe
  > INET: phowe_at_Illuminet.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > 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!?
Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Mar 05 2002 - 12:33:26 CST