Oracle GoldenGate 11gR2 Configuration On Oracle Database 11gR2 RAC ACFS

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 Oracle GoldenGate database objects.  
NOTE: The schema must be created prior to running this script.  
NOTE: Stop all DDL replication before starting this installation.  
  
Enter Oracle GoldenGate schema name:goldengate  
  
  
Marker setup table script complete, running verification script...  
Please enter the name of a schema for the GoldenGate database objects:  
Setting schema name to GOLDENGATE  
  
MARKER TABLE  
-------------------------------  
OK  
  
MARKER SEQUENCE  
-------------------------------  
OK  
  
Script complete.  
SQL> @ddl_setup  
  
Oracle GoldenGate DDL Replication setup script  
  
Verifying that current user has privileges to install DDL Replication...  
  
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.  
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.  
NOTE: The schema must be created prior to running this script.  
NOTE: Stop all DDL replication before starting this installation.  
  
Enter Oracle GoldenGate schema name:goldengate  
  
Working, please wait ...  
Spooling to file ddl_setup_spool.txt  
  
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...  
  
Check complete.  
  
  
  
  
  
  
  
WARNING: Tablespace GOLDENGATE does not have AUTOEXTEND enabled.  
  
  
  
Using GOLDENGATE as a Oracle GoldenGate schema name.  
  
Working, please wait ...  
  
DDL replication setup script complete, running verification script...  
Please enter the name of a schema for the GoldenGate database objects:  
Setting schema name to GOLDENGATE  
  
CLEAR_TRACE STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
CREATE_TRACE STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
TRACE_PUT_LINE STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
INITIAL_SETUP STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
DDLVERSIONSPECIFIC PACKAGE STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
DDLREPLICATION PACKAGE STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
DDLREPLICATION PACKAGE BODY STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
DDL IGNORE TABLE  
-----------------------------------  
OK  
  
DDL IGNORE LOG TABLE  
-----------------------------------  
OK  
  
DDLAUX  PACKAGE STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
DDLAUX PACKAGE BODY STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
SYS.DDLCTXINFO  PACKAGE STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
SYS.DDLCTXINFO  PACKAGE BODY STATUS:  
  
Line/pos             Error  
-------------------- -----------------------------------------------------------------  
No errors            No errors  
  
DDL HISTORY TABLE  
-----------------------------------  
OK  
  
DDL HISTORY TABLE(1