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:[EMAIL PROTECTED]] > Sent: Monday, August 26, 2002 11:00 PM > To: [EMAIL PROTECTED] > 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 > ([EMAIL PROTECTED]) > > > > -----Original Message----- > From: Richard L. Rhodes [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 26, 2002 6:24 PM > To: [EMAIL PROTECTED] > 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 >
