"OGG" Ogg configuration for one-way DML replication (i)

" OGG " OGG the one-way DML Replication Configuration ( i )

1. Blog Document structure diagram

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/58/wKiom1V5aJ6RIAH_AANvv9NoBos238.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 DML real-time replication capabilities

② silent installation of the database

③ OGG the installation

④ OGG initialization of the next data

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

Project	source db	target db
db Span style= "font-family: Arial" > type		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