Re: Can a Data Guard copy live on the same box?

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 31 Mar 2005 18:58:34 GMT
Message-ID: <uLX2e.5248$FN4.1563@newssvr21.news.prodigy.com>

stephen.howard_at_us.pwcglobal.com wrote:

> GeoPappas wrote:
>

>>Can both the original database and the copy of the original database
>>reside on the same box using Data Guard?

>
>
> Having it on the same machine doesn't buy you much (except for
> testing), but yes, just configure it normally as with any Dataguard
> config. You need a different instance_name (and lock_name_space if on
> Windows).
>
> Regards,
>
>
> Steve
>

The docs have more information specifically about this configuration (yes, you actually are supposed to search the docs before posting here):

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10823/standby.htm#64472

The lock name space issue is the same on Unix as on Windows. You have to be careful to configure your standby directory structure so it doesn't accidentally coincide with your primary.

One thing having a standby on the same machine as the primary does buy you is avoiding extra CPU licen$ing.

-Mark Bole Received on Thu Mar 31 2005 - 12:58:34 CST