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

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).