야솔아빠의 블로그

시나리오 설명Start the Source and Target OGG Manager processes.Create an Extract that reads from Oracle redo logs in the Source environment.Create an Extract Pump that will move captured transactions to the Target environment.Create a Replicat that will be used to sync up the two sides based on a SCN number we will get prior to an Oracle Datapump export.Start the OGG Capture process on the Source side..

Oracle/OGG 2014. 7. 21. 13:09

Source DB 의 DDL 변경을 Target DB 로 동기화 시키는 예제 환경- source DB : 10g- target DB : 11gR2 1. source DB system 설정 [oracle@ogg-wkshp 10gogg]$ cd [oracle@ogg-wkshp ~]$ source 10g.env [oracle@ogg-wkshp ~]$ cd $GG [oracle@ogg-wkshp 10gogg]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jul 9 19:07:51 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Datab..

Oracle/OGG 2014. 7. 11. 16:51

Oracle Golden Gate install and Lab 0. 환경설정OGG workshop virtual box 설치 아래 virutal box 설명정보 The following VirtualBox 4.2.6 image consists of Oracle GoldenGate labs running on OEL5, x64. The image memory is configured for 4 GB RAM and guest CPU's are set to 2. The image contains: Oracle GoldenGate 11.2 (labs available) Oracle GoldenGate Monitor Oracle GoldenGate Veridata (lab available) Oracle Gold..

Oracle/OGG 2014. 7. 4. 17:48