OraFAQ Forum: Replication » How to replicate 50GB data every day

Home » Server Options » Replication » How to replicate 50GB data every day (Oracle, 11g, solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to replicate 50GB data every day [message #622327]

Mon, 25 August 2014 03:36

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

Report message to a moderator

Re: How to replicate 50GB data every day [message #622352 is a reply to message #622327]

Mon, 25 August 2014 11:13

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

You might go with Goldengate

Report message to a moderator

Re: How to replicate 50GB data every day [message #622378 is a reply to message #622352]

Mon, 25 August 2014 19:35

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.

Report message to a moderator

Re: How to replicate 50GB data every day [message #622381 is a reply to message #622378]

Mon, 25 August 2014 22:01

babuknb
Messages: 1736
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

Report message to a moderator

Re: How to replicate 50GB data every day [message #622590 is a reply to message #622381]

Wed, 27 August 2014 20:31

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 16:11:26 CST 2025