RE: backup strategy for a database over 1 TB running SAP R/3

Rich,

Why would I want SAP to help with a database recovery?

If I need help with that, I will call Oracle, not SAP.

Not to mention that removing backint, brbackup, brarchive and brrestore from the recovery scenario eliminates the finger pointing that could go on between SAP and Oracle.

Regardless of what SAP support and SAP consultants would have you believe, the underlying database is still just a database, and SAP utilities are not required to manage it.

>From my previous experience with SAP and the Earlywatch
program, I would say that the farther SAP stays away from my databases, the better. :)

Jared

"Rich Holland" <holland_at_guidancetech.com> Sent by: root_at_fatcity.com
 04/17/2003 05:46 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: backup strategy for a database over 1 TB running SAP R/3

And as long as you don't mind relying on Oracle support to get the application running again after a recovery. If you use the SAP provided tools, SAP will assist with recoveries. If not, you're on your own...

Rich

> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_cybcon.com]
> Sent: Monday, April 14, 2003 10:35 AM
> To: ORACLE-L_at_fatcity.com; Rich Holland
> Subject: Re: backup strategy for a database over 1 TB running SAP R/3
>
>
>
> Of course, you could just skip the use of backint, as long
> as there is a competent DBA around.
>
> Many of the databaes tools in R/3 are there simply to
> compensate for not having a DBA around.
>
> Jared
>
> On Friday 11 April 2003 23:24, Rich Holland wrote:
> > Roger,
> >
> > You didn't specify what version of R/3 you're running, but for more
> > recent versions of the DB tools, you can go a couple of
> routes. SAP
> > has integrated RMAN into the BR tools and backint. This is nice as
> > you can now do consistent online backups, as well as full and
> > incrementals with RMAN, all by calling brbackup. If you're dumping
> > 1TB to Legato, I'm guessing you're using backint and a tape
> > library/backup server. One of the downsides to using the
> backint/rman
> > integration is that in most cases you'll need to purchase a license
> > from Legato for both RMAN and the backint tool, so you're in effect
> > paying twice.
> >
> > SAP has some good whitepapers on the service marketplace about the
> > integration on RMAN and the BR tools.
> >
> > You can always do the old "split mirror" backup trick as well...
> >
> > Rich Holland
> > Guidance Technologies, Inc.
> >
> > > -----Original Message-----
> > > From: root_at_fatcity.com [mailto:root_at_fatcity.com] On
> Behalf Of Roger
> > > Xu
> > > Sent: Tuesday, April 01, 2003 4:09 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: backup strategy for a database over 1 TB
> running SAP R/3
> > >
> > >
> > > Yes.
> > > In fact, I am trying to decide using RMAN or SAP BR-tools.
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, April 01, 2003 2:04 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Roger
> > > We don't run SAP, but are you considering using RMAN
> as a part of
> > > your plans?
> > >
> > > Dennis Williams
> > > DBA, 40%OCP, 100% DBA
> > > Lifetouch, Inc.
> > > dwilliams_at_lifetouch.com
> > >
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, April 01, 2003 1:39 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi,
> > >
> > > What is the backup strategy for a database over 1 TB
> running SAP R/3
> > > on Solaris? We are using Legato products and they have NetWorker
> > > Module for Oracle and NetWorker Module for SAP on
> Oracle. Which one
> > > is better?
> > >
> > > Thanks,
> > >
> > >
> > > Roger Xu
> > > Database Administrator
> > > Dr Pepper Bottling Company of Texas
> > > (972)721-8337
> > >
> > >
> > > ______________________________________________________________
> > > __________
> > > This email has been scanned for all viruses by the MessageLabs
> > > SkyScan service. For more information on a proactive anti-virus
> > > service working around the clock, around the globe, visit
> > > http://www.messagelabs.com
> > > ______________________________________________________________
> > > __________
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Roger Xu
> > > INET: roger_xu_at_dp7uptx.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).
> > >
> > >
> > > ______________________________________________________________
> > > __________
> > > This email has been scanned for all viruses by the MessageLabs
> > > SkyScan service. For more information on a proactive anti-virus
> > > service working around the clock, around the globe, visit
> > > http://www.messagelabs.com
> > > ______________________________________________________________
> > > __________
> > >
> > > ______________________________________________________________
> > > __________
> > > This email has been scanned for all viruses by the MessageLabs
> > > SkyScan service. For more information on a proactive anti-virus
> > > service working around the clock, around the globe, visit
> > > http://www.messagelabs.com
> > > ______________________________________________________________
> > > __________
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Roger Xu
> > > INET: roger_xu_at_dp7uptx.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: Rich Holland
  INET: holland_at_guidancetech.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: 
  INET: Jared.Still_at_radisys.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).