"Ogg" Ogg's one-way replication configuration-support DDL (ii)

" OGG " OGG One-way replication configuration - Support DDL ( two )

1. Blog Document structure diagram

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/58/wKiom1V5aF2T3zr-AAGlP0pKpTQ696.jpg "/>

1. Foreword part

1. Guide

Technical enthusiasts, after reading this article, you can master the following skills, you can also learn some other knowledge you do not know, ~o (∩_∩) o~:

①ogg the one-way DDL real-time replication capabilities

Note: This blog in the code part of the need to pay special attention to the place I use the * * * background and red font to express, such as the following example, the maximum archive log number of thread 1 for 33,thread 2 of the maximum archive log number 43 is a special concern.

List of archived Logs in backup set 11

THRD Seq Low SCN low time next SCN next time

---- ------- ---------- ------------------- ---------- ---------

1 32 1621589 2015-05-29 11:09:52 1625242 2015-05-29 11:15:48

1 33 1625242 2015-05-29 11:15:48 1625293 2015-05-29 11:15:58

2 42 1613951 2015-05-29 10:41:18 1625245 2015-05-29 11:15:49

2 43 1625245 2015-05-29 11:15:49 1625253 2015-05-29 11:15:53

If there are errors or imperfections in this article please correct me, itpub message or QQ can be, your criticism refers to my writing is the greatest motivation.

1. Introduction to the experimental environment

ogg1

" TD valign= "Middle" style= "PADDING-LEFT:7PX; padding-right:7px; Border-top:none; Border-left:none; Border-bottom:solid 0.5pt; Border-right:solid 0.5pt ">

Project	source db	target db
db Span style= "font-family: Arial" > type	Single instance	Single instance
db version	11.2.0.3	11.2.0.3
db Span style= "font-family: Arial" > store	fs type	fs type
oracle_sid	ogg1	ogg2
db_name