Re: Streams and Dataguard

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 3 Oct 2008 18:20:38 +0100
Message-ID: <7765c8970810031020g4326f8d8x714fbb330ad01655@mail.gmail.com>


i did. I'll experiment later and report back .

On 03/10/2008, Roman Podshivalov <roman.podshivalov_at_gmail.com> wrote:
> Did you use NOREGISTER clause for it ?
>
> DG_CONFIG=(PRIMARY,STANDBY, DB3)
> log_archive_dest_3='SERVICE=DB3 ARCH ASYNC NOAFFIRM NOREGISTER VALID_FOR=(ON
> LINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB3'
> --romas
>
> On Fri, Oct 3, 2008 at 11:22 AM, Niall Litchfield <
> niall.litchfield_at_gmail.com> wrote:
>
>> hi all I have been able to set up streams schema replication between
>> a couple of single instance dbs but I am having trouble with log
>> shipping in a dataguard environment. the dg environment has
>> log_archive_config set as DG_CONFIG=(PRIMARY,STANDBY) but setting
>> LOG_ARCHIVE_DEST_3 for db3 the proposed target results in an error
>> that db3 is not in dg_config, putting it there results in a complaint
>> that db3 isn't a standby, as I'd expect please tell me streams isn't
>> incompatible with Dataguard. 10.2.0.3
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 03 2008 - 12:20:38 CDT

Original text of this message