Physical Standby and Streams

From: UtahToad <mr.hicken_at_gmail.com>
Date: Mon, 18 Dec 2006 14:18:19 -0700
Message-ID: <4587059B.1080804@gmail.com>

We have a physical standby (DataGuard) set up and want to set up streams to a warehouse. The physical standby is functioning well , but we can't get the logs shipped over to the warehouse database. Does anyone have any experience on this type of configuration? Are there any insights for us? Could there be a missing parameter?

We think that the parameter LOG_ARCHIVE_CONFIG is the culprit. It is currently set at "SEND,DG_CONFIG=(STANDBY)" and we think it might need to be just "SEND" only, but we are hesitant to change it because it might screw up our physical standby. It originally was "DG_CONFIG=(STANDBY)". Insights, anyone?

Thanks,
David

--

David Hicken
Flying J - Senior Database Administrator david(dot)hicken(at)flyingj(dot)com

Everybody is ignorant, only of different subjects.
-- Will Rogers

--

12/18/2006 -- David Hicken
(david_hicken at networld dot com)
To him who is in fear, everything rustles.
--Sophocles

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 18 2006 - 15:18:19 CST