Home » Server Options » Streams & AQ » Oracle Streams and impdp (Oracle 10.x)  () 1 Vote
Oracle Streams and impdp [message #352549] Wed, 08 October 2008 06:35 Go to next message
renjithd
Messages: 3
Registered: October 2008
Junior Member
Hi I am not a DBA or anything close Smile .. in a project which I am working on, there are 2 or more prod servers which are connected
through streams for bi directional replication of data. Now we have to develop a back up/restore mechanism using scripts. The back up scripts take the dump using expdp of a schema and the restore script uses impdp to apply it. Is there anyway in which i can apply using impdp to one database and streams will apply in all the other database. I tried googling, yahooing, everything, but in vain. we also use dataguard, and its odd for me, dataguard applies the changes on the standby whenever i do a impdp on the primary database!!

May be my understanding in streams is wrong..

Any help is greately appreciated.

Thanks
Renjith
Re: Oracle Streams and impdp [message #353184 is a reply to message #352549] Sun, 12 October 2008 10:40 Go to previous messageGo to next message
renjithd
Messages: 3
Registered: October 2008
Junior Member
Hi..
any thoughts Sad .. i see 53 hits and no replies.. is it because the question is too stupid????

thanks
Renjith
Re: Oracle Streams and impdp [message #353187 is a reply to message #353184] Sun, 12 October 2008 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DataPump is NOT a backup method, use RMAN.

Regards
Michel
Re: Oracle Streams and impdp [message #353224 is a reply to message #353187] Mon, 13 October 2008 00:38 Go to previous message
renjithd
Messages: 3
Registered: October 2008
Junior Member
thanks for the reply...
looks like its a bug ...here is the same post i made in oracle forum and the reply...

http://forums.oracle.com/forums/thread.jspa?threadID=716855

As per this, you need install a patch 10.2.0.4 patchset (also in 11.1.0.6 -> 11g base release) and above for this to work..

Renjith
Previous Topic: Contention in stream apply process
Next Topic: stream conflict for delete, Unique key, Foreign Key
Goto Forum:
  


Current Time: Thu Mar 28 10:32:31 CDT 2024