Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Golden Gate Redundancy
tspoon
post Mar 13 2017, 08:54 AM
Post #1


Member
**

Group: Members
Posts: 25
Joined: 12-June 05
Member No.: 2,287



Hi,

I have configured OGG for one-to-one replication and working fine

Now I would like to have muliple schema's to multiple targets, using one souce Database (Master DB)

a - do I set up indivdual extract files (for each schema) that then map to their target(s)

b - as the extracts are reading from one set of redo log files, how to you legislate against failure, when the Databases roles are switched.

I understand that in DG the main DB will switch roles but at this point the scn will be out of synch for the replication and therefore
recovery will be inoperable when I switch back.

We are operating in a DG 12c env not RAC

Am I misunderstanding here - any advice will be most welcome





--------------------
tspoon
Junior Oracle DBA
United Kingdom

Oracle is a never ending learning curve
learn to share and share to enhance one's knowledge

Ron Jeremy circa 1974
Go to the top of the page
 
+Quote Post
burleson
post Mar 15 2017, 03:33 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,378
Joined: 26-January 04
Member No.: 13



Hi,

>> I understand that in DG the main DB will switch roles but at this point the scn will be out of synch for the replication and therefore recovery will be inoperable when I switch back.

You are running both Data Guard and GoldenGate?

DG is no longer supported . . .

Please read:

http://www.dba-oracle.com/t_goldengate_con...oad_extract.htm


















--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
tspoon
post Mar 22 2017, 06:04 AM
Post #3


Member
**

Group: Members
Posts: 25
Joined: 12-June 05
Member No.: 2,287



QUOTE (burleson @ Mar 15 2017, 09:33 PM) *
Hi,

>> I understand that in DG the main DB will switch roles but at this point the scn will be out of synch for the replication and therefore recovery will be inoperable when I switch back.

You are running both Data Guard and GoldenGate?

DG is no longer supported . . .

Please read:

http://www.dba-oracle.com/t_goldengate_con...oad_extract.htm


Where I am currently working for a large e-commerce company we are operating DG on 11.2.0.4. in numerous environments, including production


--------------------
tspoon
Junior Oracle DBA
United Kingdom

Oracle is a never ending learning curve
learn to share and share to enhance one's knowledge

Ron Jeremy circa 1974
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th April 2017 - 07:15 PM