Re: Backup Recovery Strategy for Large Database

In article <D2yuwt.7pB_at_lanier.com>, dvick_at_lanier.com (Don Vick) writes:
|>In article <Pine.SV4.3.91.950124081125.1063A-100000_at_gateway.ctg.com>,
|>P.E. Detzel <ctg27516_at_ctg.com> wrote:
|>>I need to develop and implement a backup/recovery strategy for a large
|>>Oracle application. This will be a global system and is required to be
|>>available 24 hours a day, 7 days a week. The platform is HP/UX and
|>>Oracle V7.0.16. It will be an 80 gigabyte system plus disk shadowing.
|>>
|>>I would like to know what backup/recovery method you use, have you had to
|>>recover, what advice/cautions/recommendations/etc you can share. Also,
|>>with the shadowed disks, is it possible to de-shadow and then perform a
|>>backup on the former shadow sets?
|>
|>We use this technique for backing up a 20+ gigabyte database that has
|>stringent uptime requirements (though not 24x7 yet). At an opportune
|>moment, we mirror the disks containing the database, then bring down the
|>database, separate the mirrored drives, and restart the database. The
|>database is down for less than five minutes, and we have a complete static
|>image that can be backed up to tape later. Maybe you can adapt this to a
|>hot backup strategy.
|>
|>Don
|>--------------------------------------------------------
|>Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com)
|>Voice: (404) 493-2194 Fax: (404) 493-2399
|>

Don,

I'd be interested to know of any performance degradation when you mirror the disks containing the database. We have thought of this, but it takes 4 hours or so to fully update the mirror disks, and performance suffers during this period. We're on VAX/VMS here.

Jen

-- 
Jennifer Corliss is on an InterGalactic cruise...       |The opinions expressed 
                                                        |above may not be those
   ...in her office                                     |of my employer.