Re: Full Database replication!!

This is a job for: "Standby Database"

Starting with some sort of physical copy of your original database you can apply all the archived redo logfiles to the standby database. Oracle supports this explicitly.
The support consists of the fact that it is not possible to accidently OPEN the database, because if you do that you can no longer apply the archived logfiles and you would have to start over again. In case of an emergency you can force the database to OPEN. Also see the official manual on this topic.

Erwin

Shaul wrote:
>
> Hi,
>
> Does anyone knows what's the best way to fully replicate a database ?
>
> I have a production database on one unix machine and I want to have a
> complete replica of this database one a second machine both on the same LAN
> (100mbit).
>
> The replica database should be exactly the same as the production, so it
> will be able to replace it in case the other machine is burnt down.
>
> The replica database should be up-to-date with the production at all times,
> minimally hurting the production's performace.
>
> If it's not possible to have an up-to-date replica without hurting
> performance, it is possible that the replica will be updated up to one day
> back.
>
> 2 more important requirements:
>
> 1) The replica should be able to replace the production at any time with
> minimal work to do.
> 2) The replica should be activated at the shortest possible time.
>
> What's the best way of implementing such a replica ??
>
> I will be thankfull for any tips / help in this matter!
>
> 10x,
>
> Shaul

--
Erwin Dondorp
<http://www.dondorp.com/> Received on Tue Oct 26 1999 - 18:26:15 CDT