No question at this time
DBA Top 10
1 M. Cadot 17000
2 A. Kavsek 14300
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4900
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48097
Total active users1702
Act. users last 24h1
Act. users last hour0
Registered user hits last week237
Registered user hits last month1339
Go up

golden gate recovery using archive log
Next thread: Please help - how to replace wmsys.wm_concat in 12c
Prev thread: disable partitioning option in 12c

Message Score Author Date
Hello, any suggestion if we can recover golden ...... Ashish R Sep 23, 2015, 09:15
You can forget about applying an archive log onto ...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Adam Hudspith Sep 23, 2015, 10:36
Dear Ashish, Please check the following MOS not...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Mirza Hidayathullah Baig Sep 23, 2015, 10:38

Follow up by mail Click here


Subject: golden gate recovery using archive log
Author: Ashish R, India
Date: Sep 23, 2015, 09:15, 816 days ago
Os info: HP - UX
Oracle info: 11.2.0.4
Message: Hello,

any suggestion if we can recover golden gate replica db by applying archive log transaction?

issue happen: yesterday our environment was stuck, extractor were get failed and so the replication. Later when oracle engineer joined in S1 issue and he starts using below commands.

alter extract extseqno 59907 extrba 112319488;
alter extract ioextseqno 59907 ioextrba 112318976;

after this startup, replicator gets failed because of data inconsistency. there are primary-foreign key relation. now I am doing it manually because my environment having few tables mismatch so complete schema export/import is not possible because of long downtime and so.

any suggestion on recovering using archive logs....

BR
Ashish
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: golden gate recovery using archive log
Author: Adam Hudspith, United Kingdom
Date: Sep 23, 2015, 10:36, 816 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: You can forget about applying an archive log onto a GG database that is a replicat of another live system.

GG uses it's own trail file to move data between extracts and replicats. It's in it's own bespoke format.

If you have data inconsistency most people would just restart the extract at a known SCN and (MAYBE) be prepared to allow the replicat to work in HANDLECOLLISIONS mode.

edit params REP1
HANDLECOLLISIONS
MAP schema.table, TARGET schema.table;

And then try and sort out inconsistency afterwards.

Personally tho... Id rebuild the table. I dont really see why thats been ruled out as an option.

Adam
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 recovery using archive log
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Sep 23, 2015, 10:38, 816 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Dear Ashish,

Please check the following MOS note

Oracle GoldenGate Best Practices: Extracting from Oracle Archive log files (ALO Mode) (Doc ID 1358342.1)

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