Oracle GoldenGate Installation

Goldengate is the industry's mature data disaster recovery and replication products, 1995GoldenGate company was founded in 1995, San Francisco, California, USA. Acquired by Oracle Corporation in 2009.

Pros: 0 Downtime Database upgrades and migrations, fast real-time data synchronization, high data availability, and reduced recovery contingency risk.

GG and DG Differences: GG is a logical level of data synchronization, support for different platform database software, DG is block-level data synchronization, does not support different database software platform.

Goldengate Technology Architecture:

Source: The initial data loading phase of the fetch process (extract), which extracts data directly from the data table, fetches the change information from the Redolog log and generates a trail file, and transmits the change information (DDL and DML) to the target side by DataPump.

Target side: The collection process (Collector) assembles the transferred database into a trail file, and then the application process (RELICAT) payload reads the trail file and resolves it to a DML or DDL statement that is applied to the target database.

Both the source-side and target-side processes are managed through the manager process.

Replication modes: One-way replication, two-way replication, point-to-point, broadcast replication, and more

Install the Software:

1:http://www.oracle.com/technetwork/cn/middleware/goldengate/downloads/index.html

Download the appropriate platform version of GG software.

2:oracle Open Archive mode: select Log_mode from V$database;

Shutdown immediate

Startup Mount

ALTER DATABASE Archivelog

ALTER DATABASE open;

(It is best to modify the archive mode ALTER DATABASE set log_archive_format= '%t_%s_%r.arc ')

3: Create the appropriate folder: Mkdir/u01/app/goldengate

chmod oracle.oinstall/u01/app/goldengate

4: Decompression software cd/u01/app/goldengate

Unzip Ogg.zip

mkdir 112101

Tar xvf ....

5: Set environment variable Vi/home/oracle/.bash_profile

Export gg_home=/u01/app/goldengate/112101

Export ld_library_path= $ORACLE _home/lib: $GG _home: $LD _librart_path

. ~/.bash_profile

6: Initialize $GG _home/ggsci

Ggsci>crate Subdirs

Ggsci>exit

7: Create GG Admin user create tablespace ggdate datafile ' ... ' size 200m;

Create user GGM identified by Oracle default Tablespace ggdate;

Grant DBA to GGM;

8: Configuration Management process: ggsci> edit params Mgr

Info Mgr

Start Mgr

9: Add additional logs: Select Supplementa ... from v$database

ALTER DATABASE add supplemental log date;

ggsci> dblogin Useid GGM

List Tables scott.*

Info Trandata scott.*

Add Trandata scott.*

This article is from the "DBA" blog, so be sure to keep this source http://duancr123.blog.51cto.com/7644884/1744229

Oracle GoldenGate Installation