Oracle GoldenGate 11gR2 Configuration On Oracle Database 11gR2 RAC ACFS
OracleOracle RACOracle ASMoracle goldengate
source
Oracle 11gR2 RAC
#public IP
192.168.1.51 vzwc1
192.168.1.52 vzwc2
#private IP
172.168.1.51 vzwc1-priv
172.168.1.52 vzwc2-priv
#VIP
192.168.1.151 vzwc1-vip
192.168.1.152 vzwc2-vip
#scanip
192.168.1.159 vzwc-cluster vzwc-cluster-scan
Target
Oracle 11gR2 single instance
192.168.1.233 ggos
on source
Create ASM volumes
[grid@vzwc1 ~]$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED HIGH N 512 4096 1048576 5120 4024 2048 658 0 N CRSDG/
MOUNTED NORMAL N 512 4096 1048576 30720 26374 0 13187 0 N DATADG/
MOUNTED NORMAL N 512 4096 1048576 30720 29724 0 14862 0 N FRADG/
MOUNTED NORMAL N 512 4096 1048576 20480 20290 0 10145 0 N OGGDG/
MOUNTED HIGH N 512 4096 1048576 5120 3867 2048 606 0 Y SYSDG/
[grid@vzwc1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 16 15:48:20 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> alter diskgroup oggdg add volume ggs size 8G;
Diskgroup altered.
Create the ACFS filesystem
[grid@vzwc1 ~]$ /sbin/mkfs -t acfs -b 4k /dev/asm/ggs-11
mkfs.acfs: version = 11.2.0.4.0
mkfs.acfs: on-disk version = 39.0
mkfs.acfs: volume = /dev/asm/ggs-11
mkfs.acfs: volume size = 8589934592
mkfs.acfs: Format complete.
Register the ASM Volume (ADVM) & ACFS filesystem in the Oracle Registry
[grid@vzwc1 ~]$ /sbin/acfsutil registry -f -a /dev/asm/ggs-11 /ggs
acfsutil registry: mount point /ggs successfully added to Oracle Registry
As root user, please mount the ACFS filesystem on the ASM Volume (ADVM)
[root@vzwc1 ~]# mount -t acfs /dev/asm/ggs-11 /ggs
[root@vzwc1 ~]# chown -R oracle.oinstall /ggs
[root@vzwc1 ~]# df -TH
Filesystem Type Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
ext3 47G 18G 27G 40% /
/dev/sda1 ext3 104M 25M 75M 25% /boot
tmpfs tmpfs 1.6G 964M 617M 61% /dev/shm
/dev/asm/ggs-11
acfs 8.6G 98M 8.5G 2% /ggs
configuration GoldenGate
add supplemental log
[oracle@vzwc1 ora]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 16 17:05:11 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
Database altered.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;
Database altered.
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
Create DDL objects
SQL> GRANT EXECUTE ON UTL_FILE TO goldengate;
Grant succeeded.
SQL> GRANT CONNECT,RESOURCE,DBA TO goldengate;
Grant succeeded.
SQL> @marker_setup
Marker setup script
You will be prompted for the name of a schema for the Ora