Re: Backups on raw devices

Michael,
 We have about 160 DBs connecting to a central RMAN Repository. All Dev/Test DBs connect to one RMAN repository on a separate UNIX box and all the production DBs connect to another Production Repository.

 Production RMAN repository is clustered using MC/Service guard for high availability. We take exports of RMAN repositories, also RMAN (Test) repository is backed-up to RMAN (Prod) repository and vice versa!

Rama

"Jenkins, Michael" wrote:

> I've logged a TAR on this one with Oracle. They have verified what I
> suspected all along. The SAs here don't understand how Oracle performs a
> hot backup. There is no difference between raw and cooked file systems as
> far as Oracle is concerned when performing a hot backup. Also, the skipping
> of the header is only applicable to certain variants of UNIX.
>
> One other question here. Does anyone have recommendations on the repository
> database required for RMAN? Do we need to keep a separate instance on
> another production box? Or the same production box? Does everybody have
> all of there repository information for all of their database in one
> instance? It seems like you would want a separate instance for each
> repository and have them staggered across different machines so that the
> odds of losing your database and it's repository at the same time would be
> low. Any suggestions?
>
> Thanks for all the replies so far!
>
> --Michael
>
> -----Original Message-----
> Sent: Friday, June 15, 2001 9:55 PM
> To: Multiple recipients of list ORACLE-L
>
> Michael,
> We use RMAN on RAW with EDM (EMC) backups, without any problem. When using
> RMAN, it will take care of all blocks that are being changed while the
> backup is
> going on. Also as EDM interfaces with the Tape library, RMAN will write
> directly
> to the Tape . Have this set up on about 15 databases and all of them are
> working
> fine. But occasionally our backups fail on 8.1.6 databases due to lack of
> resources on the Server (and some bugs!).
>
> Rama
>
> "Jenkins, Michael" wrote:
>
> > We have parallel server running on on a Sun Cluster 2.2 and we are looking
> > for the easiest way to perform hot backups. Now, I know that you have to
> > use the "dd" command and skip the header at the beginning. Everything I
> > read on metalink indicates that you can use basically the same paradigm as
> a
> > hot backup on cooked file systems. But, the sysadmins here tell me that
> the
> > raw device can't be backed up if there is any write activity on the data
> > file that is currently being backed up. Now we all know that contrary to
> > popular belief there is write activity on a data file even when the
> > tablespace is in backup mode. Is "rman" or some other block-level backup
> > utility the only way to get a reliable hot backup on raw devices? Does
> > anybody have any experience with hot backups that are made while the
> > database still has active users logged in?
> >
> > I look forward to everyone's thought on this.
> >
> > Thanks.
> >
> > Michael L. Jenkins
> > Oracle Certified DBA
> > Nextel Communications
> > Norcross, GA
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jenkins, Michael
> > INET: Michael.Jenkins_at_nextel.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jenkins, Michael
> INET: Michael.Jenkins_at_Nextel.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 Mon Jun 18 2001 - 13:03:47 CDT