Goldengate deploying oracle10g in a RAC ASM environment, complete tutorial

Objective

Goldengate again RAC environment deployment, and single-machine deployment difference is still a bit large, mainly exist in the environment.

Environment

oracle10g, Sid=rac

Preparatory work

1. On the RAC node, configure the listener dynamic registration to ensure that the goldengate user is able to connect to the instance. The installation part is divided into the source and target side

Node One configuration:

[Email protected] admin]$CatListener.ora # Listener.ora.rac1 Network Configuration File:/opt/oracle/102/db_1/network/admin/listener.ora.rac1# Generated by Oracle configuration tools. Listener_rac1=(Description_list=(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST = RAC1-VIP) (PORT =1521) (IP =First )) (ADDRESS= (PROTOCOL = TCP) (HOST =192.168.1.141) (PORT =1521) (IP =First )) )) Sid_list_listener_rac1=(Sid_list=(Sid_desc=(Sid_name=Plsextproc) (Oracle_home=/opt/oracle/102/db_1) ( Program=Extproc)) (Sid_desc=(Global_dbname= +ASM) (Oracle_home=/opt/oracle/102/db_1) (Sid_name= +ASM1)) )

[[email protected] admin]$ cat tnsnames.ora# tnsnames.ora Network Configuration File:/opt/oracle/102/db_1/ network/admin/tnsnames.ora# Generated by Oracle configuration tools. RAC = (DESCRIPTION = (address = (PROTOCOL = tcp) (host = RAC1-VIP) (PORT = 1521)) (address = (PROTOCOL = tcp) (host =    RAC2-VIP) (PORT = 1521)) (load_balance = yes) (Connect_data = (SERVER = dedicated) (service_name = RAC)  ) Listeners_rac = (Address_list = (address = (PROTOCOL = TCP) (HOST = RAC1-VIP) (PORT = 1521)) (address = (PROTOCOL = TCP) (host = RAC2-VIP) (port = 1521))) RAC2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (host = RAC2-VIP) (Port = 152 1)) (Connect_data = (SERVER = dedicated) (Service_Name = RAC) (instance_name = RAC2))) RAC1 = (DES      Cription = (ADDRESS = (PROTOCOL = TCP) (HOST = RAC1-VIP) (PORT = 1521)) (Connect_data = (SERVER = dedicated)      (service_name = RAC)  (instance_name = Rac1)) ) Extproc_connection_data = (DESCription = (Address_list = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))) (Connect_data = (SID = Plsext  Proc) (PRESENTATION = RO))) ASM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.141) (PORT =    1521)) (Connect_data = (SERVER = dedicated) (service_name = +asm) (Sid_name = +ASM1)) )

Node two same configuration, remember to modify the corresponding parameters

Restart monitoring

[[email protected] admin]$ srvctl stop listener-n rac1[[email protected] admin]$ srvctl stop listener-n rac2[[email Prot Ected] admin]$ srvctl start listener-n rac1[[email protected] admin]$ srvctl start listener-n rac2

Checking ASM Instances

[Email protected] admin]$ export oracle_sid=+Asm1[[email protected] admin]$ sqlplus/As Sysdbasql*plus:release10.2.0.1.0-Production on Thu June2  -: on:Wuyi  .Copyright (c)1982,2005, Oracle. All rights reserved. Connected to:oracle Database 10g Enterprise Edition Release10.2.0.1.0-64bit Productionwith The partitioning, Real application Clusters, OLAP and Data Mining optionssql> Conn sys/111111@192.168.1.142:1521/+ASM as sysdbaconnected.

SOURCE side:

2. Installing Goldengate

Tar xvf xxxxxx.tar.gz

CD xxxx

[[email protected] oracle]$./2> Create Subdirs

[Email protected] gg]$./ggsci

Configure GG's MGR Port, the target side also needs to do the same configuration

5>5>78095>info Mgr   

--Installation Complete

3. Database environment preparation, add additional log

Original database Oracle----, ALTER DATABASE add supplemental log data;  Add additional information alter system switch logfile; View select Supplemental_log_data_min from V$database; Must be Yes

4.Goldengate synchronization users, I default with system, to avoid the permissions tangled.

5. Enter./ggsci Open the Attachment log information for the table you want to synchronize

3 111111  3> dblogin userid [email protected] 192.168. 1.141:1521111111
--Add a table with additional logs
Add Trandata gg.t1 or gg.*

6. This step adds the crawl process, and the transport process, WAN represents the crawl process, Pwan represents the transport process

Ggsci (RAC1) 8> edit param Wanggsci (rac1) 8> view param Wan            EXTRACT wanuserid [email protected]:1521/rac,passwo RD Wan--logged-in user tranlogoptions asmuser [email protected],asmpassword 111111  --Log in to ASM Exttrail./dirdat/et      -- Fetch the data put here table wan.t1;   --Grab Table Ggsci (RAC1) 8> Add Extract Wan, Tranlog, Begin now  threads 2  --rac There are several threads 2 write a few ggsci (RAC1) 8> Ad D exttrail./dirdat/et, Extract Wan, megabytes 5  --build./dirdat/et file is 5mGGSCI (rac1) 10> edit param Pwanggsci (RAC1) 1 1> view param pwanextract pwanrmthost 192.168.1.105,mgrport 7809,compress  --Transfer to the target database server Rmttrail./DIRDAT/WW  --Remote target storage data file passthrutable wan.t1;  Ggsci (RAC1) 11> add Extract Pwan, Exttrailsource./dirdat/et   --Transfer process Pwan, extracted data file path Ggsci (RAC1) 11> Add rmttrail ./dirdat/ab, Extract Psalesab, megabytes 5-establishes the data file for the target database./dirdat/ab to 5m

Ggsci (RAC1) A> Start Extract *--start up a good process Ggsci (RAC1) A>InfoAllprogram Status Group Lag time Since Chkptmanager RUNNING EXTRACT RUNNING Pwanxx:xx:xx      xx:xx: .EXTRACT RUNNING WANxx:xx:xx      xx:xx: ,    

View report WAN Log  --if it cannot be started, check the log with this command

Target side

Description: The target side creates a write process, which I named Rwan

1. Installing Goldengate

Tar xvf xxxxxx.tar.gz

CD xxxx

[Email protected] oracle]$./2> Create Subdirs

[Email protected] gg]$./ggsci

Configure GG's Mgr Port, the source side also needs to do the same configuration

5>5>78095>5Info Mgr

Configure a table to check data consistency

Edit global data File   //Add Check Data consistency table edit params./globalscheckpointtable system.checkpointtable Save CREATE TABLE dblogin userid system, Password Oracleadd checkpointtable

Add a Rwan configuration file

8>111111handlecollisionsassumetargetdefs--DDL includeAll--  Ddlerror default Ignore Retryopdiscardfile. /dirrpt/rwan.dsc,appendmap wan.t1, target chis.t1;

Add Rwan Process

8>

Start the start Replicat Rwan

Ggsci (GG) 9> info allprogram     Status      Group       Lag time           Since chkptmanager     RUNNING                                             Replicat    RUNNING     rwan        00:00:00      00:00:07  

The configuration was successful.

Summarize

The source side of the database to a table, do a DLL operation, the target side has been patched way to add, after the addition, the Rwan process needs to restart.

The following articles are referenced in the re-configuration process:

Https://blogs.oracle.com/imc/entry/oracle_goldengate_configuring_ddl_replication

http://www.ibmdba.com/?p=129

Http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/orcl_orcl/index.html

Goldengate deploying oracle10g in a RAC ASM environment, complete tutorial