Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to deploy a 24hrs , 7 days a week kind of database environment?

Re: How to deploy a 24hrs , 7 days a week kind of database environment?

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Thu, 5 Nov 1998 07:13:26 -0800
Message-ID: <Pine.OSF.3.95.981105071102.7942A-100000@gonzo.wolfenet.com>


On 4 Nov 1998, Rita and Casper wrote:
>
> While I recognize that some environments really do need absolute 7x24x365,
> but I would venture that a large percentage of these demanding environments
> could live with that 24 being 23.96; if those 2 minutes come at predictable
> times. If you can live with 2 minutes of Oracle downtime per day, you could
> have daily offline backups and your recovery would be much less painful.
> To do this you could use disk mirroring (three in a group is best). Shutdown the
> database at some pre-ordained time, remove one of the three copies from the
> disk mirrors and then re-start the database. The operation would take 2 minutes
> or less (depends on the machine / OS). Then do your backup from the split
> mirror. Once your backup is finished just re-sync the third copy with the rest
> a keep on going.

Why shut the database down? Why not just put it in backup mode, break off the mirror, and take it out of hot backup mode? That way, you don't have to schedule any downtime, however brief, for backups.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Thu Nov 05 1998 - 09:13:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US