Replication :: Golden Gate Software?

Jan 14, 2012

I want to learn Golden gate from the scratch.

1) Link for downloading golden gate software. I want to use it on oracle 11g on linux (X86). ( I have downloaded fbo_ggs_Linux_x64_ora11g_64bit.zip from oracle.com size 89mb but I'm not sure whether this is the actual version or not!)
2) Easy ,step by step guide to install the software.
3) Documents/link for performing basic operation.

View 3 Replies


ADVERTISEMENT

Golden Gate Replication

Apr 29, 2013

Below questions are swirling in my mind while doing some research on Golden gate setup and replication

1) Can we put any time delay between source and target, so that the replication data will be applied after some set of time?

2) If I setup the Golden Gate between Oracle as source and SQL server as destination, then how the core of procedures/views/functions/packages will be replicated to SQL server target?

i.e. is only data replicates between the DBs or the other procedures/views/packages.. etc will also be replicated? If not,then do we need the manual involvement to replicate them?

3) Is it possible to replicate the schemas within the same DB using golden gate?

i.e. if TOOLS DB is shaving schemas A and B, can I replicate the A objects to B schema within the same DB TOOLS?

View 1 Replies View Related

Replication :: Golden Gate For Production Cut Over

Feb 4, 2012

I was planning to a production cut over from Aix to linux .I thought GG as an option so that i can have two DBs run parallel and replicate and do a cutover to linux during the change window.

Now the problem i see is that only half the tables have primary key.. so I THINK golden gate cannot be used an an option.

View 2 Replies View Related

Replication :: Bi-Directional Replication Through Golden Gate?

Aug 22, 2010

For using replication in our production, here i am testing golden gate as replication tool. I tested all scenario in Uni direction ( source to destination). Now have to test replication with DDL support in Bi-Direction. Not getting any Doc for doing replication in Bi-direction( Two Way). If any one has done the same, then please share limitation of replication in Bi-direction through Golden Gate.

View 7 Replies View Related

Golden Gate Bidirectional Replication Inconsistency

Mar 3, 2011

I was trying to test out the bidirectional replication using golden gate 11g . while doing some tests i did find out there are inconsistency in the database.

Scenario:

Database 11gee,Goldengate11g.

Set up a bidirectional replication replication it works fine until i hit the below scenario. I updated 1 record in the source database then i updated same record in the target database . Now i issued commit one by one on both the src/target. Now checking the record in src/target have different values. src containing the value which was committed in target and vice versa in target. leading to data integrity.

How can we resolve the above issues i have tried different options but nothing seems to work till now.

View 1 Replies View Related

Replication :: Golden Gate - Manager Not Starting?

Oct 3, 2010

Trying to configure oracle golden gate between oracle 10g and 9i golden gate Manager is not starting

Error in MGR.rpt

Source Context :
SourceModule : [mgr.main]
SourceID : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/app/mgr/mgr.c]
SourceFunction : [param_file_args]
SourceLine : [2854]

2010-10-03 09:27:48 ERROR OGG-00303 Unrecognized parameter (<CODE>PORT).
2010-10-03 09:27:48 ERROR OGG-01668 PROCESS ABENDING.

View 1 Replies View Related

Replication :: What Is Stream's Tag Equivalent In Golden Gate

Apr 13, 2012

What is the stream's "tag" equivalent in Golden gate ?My tables are already in GG replication, but i want to do few insert in to source which i dont want to replicate to target.

View 1 Replies View Related

Replication :: Meaning Of BOUNDED RECOVERY In Golden Gate

Jan 8, 2012

whats the meaning of BOUNDED RECOVERY in golden gate. I just know RECOVERY in oracle.. What is the difference when you say BOUNDED RECOVERY.

View 1 Replies View Related

Replication :: Golden Gate - Replicate Data From Oracle To Sybase

Oct 17, 2007

Implemented the Golden Gate replication tool? In particular, to replicate data from Oracle to Sybase?

No details are needed, just a quick nod indicating "yes, it has been done successfully".

View 1 Replies View Related

Golden Gate Errors Out While Configuring?

Aug 18, 2011

I am trying to configure Golden Gate but i am running into the following errors while configuring. Given below is the contents of the configuration.

ggssci>edit params mgr
PORT 7809
USERID ggs_owner, PASSWORD ggs_owner
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/ex, USECHECKPOINTS

[Code].....

View 1 Replies View Related

Networking And Gateways :: Oracle Golden Gate For SQL Server

Mar 11, 2013

Currently we are loading data from oracle to sql server through oracle 11g gateway. during running scripts most of the queries takes a long time to complete. Because of this performance issue, we want to configure oracle golden gate to move data from oracle to sqlserver. whats the difference between oracle gateway & oracle golden gate? both are performing same functionality?

View 1 Replies View Related

Replication :: Oracle Streams / Tried Schema Replication Through Enterprise Manager Grid Control

Feb 22, 2012

Actually am trying to replicate two db servers from one in hong kong and another in china. when am trying to establish the replication, am getting error 'ORA-04052: error occurred when looking up remote object' like this...

but the same way i have tried in my local network, it is working fine.i have tried schema replication through enterprise manager grid control..

View 6 Replies View Related

Replication :: Network Requirements For Oracle Multi Master Replication?

Apr 1, 2010

what are the recommended network requirements for implementing Oracle Multi Master replication.

View 1 Replies View Related

Replication :: Setup Database Replication With Updatable Materialized View?

Sep 4, 2009

i need to set up a central server with all the master tables and two other local database which will hold the updatable materialized view of the master table...the databases must be synchronized with central server..and user will work on the materialized view database...

View 10 Replies View Related

Replication :: Setting Replication Table Does Not Exist Or Is Invalid

Aug 21, 2008

I want to set up advance replication for 3 master site (multimaster) I created 3 master site named orc1,orc2,orc3 and followed up oracle replication management of API book instruction I created 2 tables(tes1,test2) in hr schema in all 3 master site with the same data. then I created the following steps

1-CONNECT repadmin/repadmin@orc1

2-Create the master group named hr_test_repg

BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP(
gname => 'hr_test_repg');
END;
/

4-add tables test1 and test2 to the group

BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
gname => 'hr_test_repg',
type => 'TABLE',
oname => 'test1',

[code]....

I could create DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for test2 but not for test1 and it produces error

RROR at line 1:
RA-23309: object hr.test1 of type TABLE exists
RA-06512: at "SYS.DBMS_SYS_ERROR", line 105
RA-06512: at "SYS.DBMS_REPCAT_MAS", line 2552
RA-06512: at "SYS.DBMS_REPCAT", line 562
RA-06512: at line 2

View 5 Replies View Related

Replication :: Selective Incremental Replication Between Two Instances?

Aug 4, 2009

I have one 10g database in other country. I want part of their db (selected tables or tablespaces) and import that data to my 10g DB and i want keep to date this data.

I know two ways

1. Data Pump Imp/Emp via FTP, but i can't send only data that have changed (incremental), i must pumping whole selected part of database (i want only new data from their DB, but consistanse with my DB)

2. RMAN etc. or other archivisation tool, i can do incremental achivisation, but can i send files to another instances (my db) and load only that data? Can i do that with SQL*Loader?

View 1 Replies View Related

Replication :: Refreshing The Tables In Multimaster Replication?

Oct 14, 2008

I have 8 databases in a multi master replication. I want to refresh the tables in the replication.

View 3 Replies View Related

Replication :: Getting Error In Configuration Of Replication Between Two Databases

Jan 28, 2011

I Have configured the replication between two database's at table level. After few miniuts of successful configuration of replication between two db's at table level, I am getting the ORA-00001: unique constraint (%s_PK) violated error in dba_apply_error.

I checked constraint name,type and status on table replicated is same on both source and destination db.

View 4 Replies View Related

Replication :: Should Target DB In Replication Be In Archive-log Mode

Jul 26, 2008

I am implementing one-way replication between 2 databases.

Do people leave the target database in archive-log mode? Do they backup the target database?

View 4 Replies View Related

Replication :: How To Make Replication For Destination Only

Apr 1, 2013

How can i make replication at one way For destination only. Not for destination and target.

View 5 Replies View Related

Replication :: Oracle Replication Between Different Versions?

Sep 17, 2008

I need to do a Oracle replication between databases. One resides on Oracle 8i which needs to be replicated to a database on Oracle 10G.

Is oracle replication supported between dissimilar versions of Oracle?

View 3 Replies View Related

Replication :: Impact Of Triggers On Replication

Oct 28, 2009

I am using prebuilt MV to perform replication of about 300-400 master tables from one database to another database. I am wondering about the impacts on triggers in general replication.

IS there a general rule to enable/disable a trigger before a refresh.

View 1 Replies View Related

Replication :: Oracle 8i Asynchronous Replication

Apr 9, 2012

I want to configured A Synchronous replication in oracle 8i. Noe using GUI i am bale to create replication but whatever i modify it remain in the transaction i have to manually run the job ,

I also tried to configured continuous asynchronous configuration by setting delay rate 500000. but it was also not working.

View 2 Replies View Related

Replication :: One Way Replication From MS Sql Server To Oracle 10g

Feb 11, 2010

Is it possible to replicate table data on real time from sql server (2005 32 bit or sql server 2000 32 bit)to oracle 10g running on linux 64 bit? If yes then what are the steps.

It will be one way replication from sql server to oracle. Which option is best sql server dts or Oracle Stream replication to replicate table data.

View 3 Replies View Related

Replication :: How To Use Replication For Backup

Dec 3, 2007

We have two ORACLE-Standard-Edition installations, one is installed on a machine in our production department and one is installed on an central server. We want to replicate the data from the production-DB to the central server to backup the data on tape drives.

Is this possible using the feature of standard edition?

View 9 Replies View Related

Replication :: Set Up Replication Between Three 10g R2 Databases

Jan 14, 2011

I need to set up replication between three 10g R2 databases.There will be one main database where the data will flow into two small databases. A little bit of information will flow back from these smaller databases into the main one.

I have been asked to evaluate ODI as an option. Unfortunately I cannot use Golden Gate due to the cost.I've had a play with ODI and it looks like it's all done on a GUI where I would much prefer to be using command line scripts for setup and monitoring.

It also looks like ODI is more geared to integrating data from many different sources but I'm just going from Oracle to Oracle so don't know if it's a bit overkill.

I'm thinking of just looking at CDC which I can set up with scripts and looks to be the basis behind ODI anyway (when it comes to taking data from Oracle) - again. I may even go down the streams route that I have used before.

View 7 Replies View Related

Replication :: MVs Associated With A MV LOG?

Feb 5, 2009

I have an MV Log in my database. is there any ways to find what are the MVs associated with this MVLog, from other databases ?

View 6 Replies View Related

Replication :: Between 10g And 11g On Oracle?

Sep 4, 2010

Can I do replication between Oracle 10g and 11g?

The Oracle 10g running on windows xp and oracle 11g running on windows 7.

View 12 Replies View Related

Replication :: In 10G Without DB Links

May 24, 2010

We have two databases A and B, both are 10g Enterprise edition and we have to replicate only one table from A to B. A is the source and B needs a read only copy. The source of A is modified by User through Oracle Forms.

A latency of 1day can be accepted though the lesser the better. The problem is that this company does not approve of DB links in any form or any tool which in the end has to create a DB link.

View 2 Replies View Related

How To Setup One Way Replication In Database

Jul 26, 2012

I want to setup one way replication in oracle 10g Database.

Example: There are 2 database in two locations.DB1 and DB2.

DB1 need to get data from DB2 every one hour and update in DB1 database.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved