GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate Batch replication versus Data Pump Exp-Imp

837734Feb 15 2011 — edited Feb 21 2011

Hi
I am having one Production Server where lot of DBMS jobs for 4 to 5 hours are running after closure of business hours.

Procedure:

Time Activity

T1 DBMS jobs run
T2 DBMS jobs run
T3 For Generating Reports
T4 DBMS jobs run
T5 DBMS jobs run

For reporting purpose I wish to use another server so that it does not halt at time T3 and can go ahead for execution.

I have two solutions on hand.

(A) At time T3 start Golden Gate batch replication. After the updated data ( i.e till T2 ) is replicated start with T3 step

(B) Take incremental backup after T2 and import to Reporting Server. After backup is taken go ahead with T3.

Which solution will take lesser time ? Incremental Backup or Golden Gate batch replication ?

Thanks for your inputs.

Hiren Pandya

This post has been answered by MikeN on Feb 15 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 21 2011

Added on Feb 15 2011

#goldengate

2 comments

282 views