Home » Server Options » Replication » How to replicate 50GB data every day (Oracle, 11g, solaris 10)
icon5.gif  How to replicate 50GB data every day [message #622327] Mon, 25 August 2014 03:36 Go to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Hi all,

I need replicate 50GB data every day from Oracle 11G on Solaris 10 to MSSQL2014 on MS server 2008 OS.
I loaded 50GB data by sqlldr to Oracle DB and archive mode was disable on the server.

How to do it? Which approach available on the world?

Best Regards
Re: How to replicate 50GB data every day [message #622352 is a reply to message #622327] Mon, 25 August 2014 11:13 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

You might go with Goldengate
Re: How to replicate 50GB data every day [message #622378 is a reply to message #622352] Mon, 25 August 2014 19:35 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Archive log disabled and data loaded by sqlldr means I cannot use Goldengate solution. Because this solution extract data from redo/archive log files.
Re: How to replicate 50GB data every day [message #622381 is a reply to message #622378] Mon, 25 August 2014 22:01 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Yes. Database should be in archive mode.

Is daily your doing the data load using SQLLDR after truncate the target table ? If yes look something using MV using fast refresh.

https://community.oracle.com/thread/2418327
Re: How to replicate 50GB data every day [message #622590 is a reply to message #622381] Wed, 27 August 2014 20:31 Go to previous message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Babuknb

No, I merged target table (populated by sqlldr) to a partitioned table in Oracle.
Previous Topic: How to know the log generation for an update statement
Next Topic: OGG-00146 VAM function VAMInitialize returned unexpected result: error 600
Goto Forum:
  


Current Time: Wed Jan 27 14:45:12 CST 2021