No question at this time
DBA Top 10
1 A. Kavsek 12400
2 M. Cadot 7300
3 B. Vroman 6400
4 P. Wisse 5600
5 J. PĂ©ran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 A. Chavan 300
9 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48458
Total active users1485
Act. users last 24h4
Act. users last hour0
Registered user hits last week184
Registered user hits last month815
Go up

Golden Gate Replication
Next thread: Create standby using backup sets (from Oracle 12c)
Prev thread: Oracle easy connect

Message Score Author Date
Hi All, Hope all is well for everyone. ...... Santhosh Kumar Jul 22, 2019, 07:51
Hi, What error or warning message do you get? Wh...... Lauri Jul 22, 2019, 15:30
I was able to solve it by executing the below comm...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Santhosh Kumar Jul 23, 2019, 05:25
Tnaks for the feedback.... Lauri Jul 23, 2019, 09:00

Follow up by mail Click here


Subject: Golden Gate Replication
Author: Santhosh Kumar, Singapore
Date: Jul 22, 2019, 07:51, 138 days ago
Os info: Linux
Oracle info: 12c
Message: Hi All,



Hope all is well for everyone.



I had a working GG env. It was working well . Now I had created a new database in a new server by refreshing it from the source database.

Now I need to replicate the source to the new database that I created. I had changed the tnsnames entry in the golden gate replication server to point to the new db that I replicated so that the replication process will be pointing to the new DB that I created. I had started created the check point table and started the replication process. The replication process started, no error but not replicating the source data.



I can see the EXTRACT process created the files bb000000039 , transferred to the GG server as bb000000039 , but the replicate process is looking for file bb000000000. So my question is how can I ask replicated process to starts with bb000000039 instead of bb000000000?



Appreciate your advice for this asap





info EXTRACT1





EXTRACT EXTRACT1 Last Started 2019-07-22 03:08 Status RUNNING

Checkpoint Lag 00:00:10 (updated 00:00:02 ago)

Process ID 1443

Log Read Checkpoint Oracle Integrated Redo Logs

2019-07-22 04:21:42

SCN 0.11012961 (11012961)





info REPLCAT1





REPLICAT REPLCAT1 Last Started 2019-07-22 03:18 Status RUNNING

INTEGRATED

Checkpoint Lag 00:00:00 (updated 00:00:03 ago)

Process ID 1557

Log Read Checkpoint File /goldengate/dirdat/bb000000000

First Record RBA 0
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Golden Gate Replication
Author: Lauri, Netherlands
Date: Jul 22, 2019, 15:30, 137 days ago
Message: Hi,
What error or warning message do you get?
What can you find in the GG log?

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Golden Gate Replication
Author: Santhosh Kumar, Singapore
Date: Jul 23, 2019, 05:25, 137 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: I was able to solve it by executing the below command

Alter replicat replicat1, extseqno 39, extrba 0
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Golden Gate Replication
Author: Lauri, Netherlands
Date: Jul 23, 2019, 09:00, 137 days ago
Message: Tnaks for the feedback.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here