Explore Oracle Goldendate Configuration

Oracle's goldendate is a software used to do data disaster recovery is commonly known as OGG, of course, can also be used to support the hot backup database, and cross-platform cross-database data migration, specific understanding can be self-Baidu. His concept is not what I want to write here.

• Preparatory work
  

1. Download Ogg media and unzip the installation, modify the Oracle User environment variables (because relatively simple is not here to repeat, if not, can self-Baidu).

2. Because it is primarily based on database journaling, it is recommended that you open the database archive. and open additional logs for the database to more accurately capture the DML operations of the database.

3. Both the source and target databases have to establish a user for Ogg synchronization.

• Source-side Ogg configuration

1. Configure MGR Process, MGR for OGG daemon

Execute ggsci command with Oracle user to enter OGG

Then perform the following edits

Ggsci (oracle1) 2> edit params Mgr

PORT 7809

Dynamicportlist 7800-8000 (dynamic port settings, Ogg can customize the maximum of 256 ports, when the specified port is not available, the management process will select a port from the list, the source and destination of the sending accept process will use these ports)

AutoRestart Extract *,retries 2,waitminutes 2,resetminutes 5

(This represents a total of attempts to start two times, after 5 minutes of zeroing, and then in accordance with 2 minutes to try, altogether started 2 times)

Start the MGR Process

Ggsci (oracle1) 3>start Mgr

2. Configuring extract (Extraction process)

The extraction process group is run at the source and is responsible for capturing the data that needs to be transferred

Ggsci (oracle1) 5>edit params Eora (Create a extraction process named Eora)

Extract Eora

Dynamicresolution

UserID Ogg,password ogg (ogg username and password)

Exttrail/u01/app/ogg_11c/dirdat/et (trail file's storage path)

Table scott.*; (The table to synchronize, * represents all tables in that mode)

Add the extracted process that you just configured on the source side

Ggsci (oracle1) 8> Add extract Eora,tranlog,begin now

Add the path to the tail file on the source side

Ggsci (oracle1) 3> Add exttrail/u01/app/ogg_11g/dirdat/et,extract Eora

Exttrail added.

Start extract

Ggsci (oracle1) 4> start extract Eora

3. Configure the source-side pump process (send process)

Ggsci (oracle1) 5> edit params pump_so

Extract Pump_so

Dynamicresoulution

PassThru

Rmhost 192.168.230.129,mgrport 7809,compress (remote IP and management ports)

RMTTRAIL/U01/APP/OGG_11G/DIRDAT/PT (path to remote tail file)

Table scott.*;

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

Ggsci (oracle1) 6> Add extract Pump_so,exttrailsource/u01/app/ogg_11g/dirdat/et

EXTRACT added.

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

Ggsci (oracle1) 7> add rmttrail/u01/app/ogg_11g/dirdat/pt,extract pump_so

Rmttrail added.

Start the Send process

Ggsci (oracle1) 8>start Pump_so

4, you can check the configuration of the situation through info all, and whether all are working

• Target OGG program configuration
  

1. MRG for configuration target (management process)

[email protected] ogg]$ ggsci

Ggsci (oracle2) 2> Edit params Mgr (name Mgr)

PORT 7809

Dynamicportlist 7800-8000 (dynamic port settings, Ogg can customize the maximum of 256 ports, when the specified port is not available, the management process will select a port from the list, the source and destination of the sending accept process will use these ports)

Autostart ER *

Autostart Extract *,waitminutes 2,retries 5 (this representative tries to start two times, after 5 minutes of zeroing, and then in accordance with the 2-minute attempt, altogether starts 2 times)

Lagreporthours 1 (Mgr Check extract delay every 1 hours)

Laginfominutes 3 (if it takes more than three minutes to log him as a delay message to the error log)

Lagcriticalminutes 5 (if more than 5 minutes, write him as a warning in the error log)

Purgeoldextracts/u01/app/ogg_11g/rt*,usecheckpotints,minkeepdays 3 (automatically cleans up tail files, keeps only three days)

Start the MGR Process

Ggsci (oracle2) 3>start Mgr

2. Add Checklist

Note: When we specify the default checkpoint in the Globals file, the new Replicat groups automatically uses this parameter when it is created, no additional instructions are required

1) Edit the global configuration file

Edit params./globals
Checkpointtable Ogg.checkpoint

2) Exit # Here you need to exit Ggsci terminal

3) Add Checkpoint table

./ggsci

Ggsci (slave) 1> dblogin userid Ogg,password ogg
Successfully logged into database.

Ggsci (slave) 2> add checkpointtable ogg.checkpoint
Successfully created Checkpoint table OGG. CHECKPOINT.

Once added, you can see a table with two check starts in the data

sql> select Tname from TAB;  
TNAME  
-------------------------------------  
checkpoint                      table 
checkpoint_lox                  TABLE

SELECT * FROM Checkpoint;

Note 1:ogg_11.1.1.1.2 only checkpoint a single table.
Note 2:ogg_11.2.x.x.1 has checkpoint,checkpoint_lox two sheets.

3. Replicat of configuration target (loading process)

Ggsci (oracle2) 3> edit params repl

Replicat REPL

UserID Ogg,password ogg

Assumtargetdefs

Reperror Default,discard

DISCARDRDFILE/U01/APP/OGG_11G/DIRRPT/REP1.DSC, append, megabytes 50

Dynamicresolution

Map Scott.*,target scott.*;

Add a replicat process to the target side

Ggsci (Oracle2 as [email protected]) 6> add Replicat relp,exttrail/u01/app/ogg/dirdat/pt, Checkpointtable ogg. CHECKPOINT
Replicat added.

Start the Mount process

Ggsci (Oracle2 as [email protected]) 7>start Repl

Iv. Normal data test

Simply modify the data in a Scott table and look at the data corresponding to the target database.

Data synchronization can be viewed through the View report process name command and the stats process name two commands.

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

This article is from the "Scholar" blog, please be sure to keep this source http://huanming.blog.51cto.com/10214925/1671761

Explore Oracle Goldendate Configuration