Re: Backup Recovery Strategy for Large Database
Date: Thu, 2 Feb 1995 15:06:24 GMT
Message-ID: <D3DoMp.AKz_at_lanier.com>
In article <3gp6ua$ads_at_yoda.syntex.com>, <rjen_at_rvax.syntex.com> wrote:
>
>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
>|>> ...
>|>
>|>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.
>|>
>
>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.
>
The systems people tell me there is a noticeable performance degradation during mirroring. Operations schedules it during a light-load period, so it has not been a problem for us. This on a Sequent with multiple Pentiums.
Don
Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com) Voice: (404) 493-2194 Fax: (404) 493-2399 Received on Thu Feb 02 1995 - 16:06:24 CET