From: rjen@rvax.syntex.com () Newsgroups: comp.databases.oracle Subject: Re: Backup Recovery Strategy for Large Database Date: 1 Feb 1995 23:53:46 GMT Organization: Syntex Corporation Lines: 42 Distribution: world Message-ID: <3gp6ua$ads@yoda.Syntex.Com> References: Reply-To: rjen@rvax.syntex.com () NNTP-Posting-Host: rvax5.syntex.com X-Newsreader: mxrn 6.18-9 In article , dvick@lanier.com (Don Vick) writes: |>In article , |>P.E. Detzel 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@lanier.com, dvick@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.