Mike -

We do a nightly on-line backup with TDP/R3, Sunday thru Friday. The Saturday
evening backup actually starts at 12:01 AM SUnday and is an off-line, also
done with TDP/R3. We looked at RMAN (If I'm remembering right) and decided
it didn't bring anything to the table for us. The on-line backups are now
down to 2 hours 36 minutes; the off-line runs a bit longer because it stops
and restarts the Oracle instance. Even so, last week only ran 2 hours 42
minutes.

Everything we do is geared toward rapid recovery at the D/R hotsite --
that's why I run a weekly archive of the non-database SAP filesystems. We
can recover form the archive and then do point-in-time restore from there in
roughly on third the time it takes to do point-in-time for the empty
filesystems. If we really end up in a crunch, we could skip the PIT recovery
and just go with the archive restore.

Getting the throughput is a simple matter of tweaking :-)

Tom Kauffman
NIBCO, Inc

> -----Original Message-----
> From: Mike Wiggan [mailto:Michael.MA.Wiggan AT PDO.CO DOT OM]
> Sent: Monday, August 26, 2002 11:00 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Backup of 300 GB Data within 12 Hours
>
>
> Tom,
>
> I too am interested as our Database will grow to 300GB and I
> believed we
> could backup and restore in two hours.
>
> Do yo backup the full 650GB each night with Util or do you
> use Rman and
> incrementals?
>
> Many Thanks
>
> Mike Wiggan, TCS/31
> Infrastructure Integration Specialist
> Petroleum Devlopment Oman LLC
> (michael.ma.wiggan AT pdo.co DOT om)
>
>
>
> -----Original Message-----
> From: Richard L. Rhodes [mailto:rhodesr AT FIRSTENERGYCORP DOT COM]
> Sent: Monday, August 26, 2002 6:24 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Backup of 300 GB Data within 12 Hours
>
>
> On 26 Aug 2002 at 9:00, Kauffman, Tom wrote:
> > I do a 650+ GB SAP/R3 database in 2 hours 40 minutes. TSM and SAP on
> > RS/6000 systems (660-6M1 now, was S7A two weeks ago). All
> disk is IBM
> > ESS and the backups run over two dedicated Gigabit ethernet networks
> > to four IBM LTO tape drives. No compression on the client.
> The restore
> > runs in about 5 hours. The files average about 10 MB each,
> as TSM sees
> > them (1.6 GB objects, six-way multiplexing).
>
> I'm a little confused by your configuration. . . .
>
> 650gb database in 10mb files?  That would be 65000 files.  Did you
> mean 10gb/file?
>
> 1.6gb objects?  Doesn't tsm see the individual files?  Are you doing
> raw backups of the filesystems?
>
> six-way multiplexing?  I didn't think tsm supported multiplexing
> (multiple datastreams concurrently onto one tape), or is this
> something else? Is this something brbackup does?
>
>
> Sorry for the questions, but I'm interested in your specifics, since
> we will be backing some very large SAP databases to LTO in the near
> future.
>
> Thanks
>
> Rick
>