CentOS6u9 Oracle11g RAC 搭建部署（七）OGG预部署

11-OGG预部署：

1° 格式化挂载ogg数据分区：

# 节点1操作
su -
echo -e 'n\np\n1\n\n\nw\n'|fdisk /dev/mapper/lun_ogg01
partprobe /dev/mapper/lun_ogg01
mkfs.ext4 /dev/mapper/lun_ogg01p1
mkdir /ggs
echo -e '/dev/mapper/lun_ogg01p1\t/ggs\t\text4\tdefaults\t0 0'>>/etc/fstab
mount -a
chown oracle: /ggs/ -R

2° 配置grid用户下的ASM实例监听：

# 两节点均操作
su - grid
cat >>$ORACLE_HOME/network/admin/listener.ora<<EOF
SID_LIST_LISTENER =
(SID_LIST =
 (SID_DESC =
  (GLOBAL_DBNAME = +ASM)
  (ORACLE_HOME=/u01/11.2.0/grid)
  (SID_NAME = ${ORACLE_SID})
 )
)
EOF
# 重启监听
srvctl stop listener
srvctl start listener
crsctl stat res -t
# 测试
sqlplus sys/oracle@rac01:1521/+ASM as sysdba
show parameter name;
conn sys/oracle@rac02:1521/+ASM as sysdba
show parameter name;
exit

3° 配置oracle用户下的tnsnames.ora：

# 节点1操作
# 配置LOCAL标签为本机，配置REMOTE标签为远端，非集群另外一个节点
su - oracle
# 设置远端IP和SID，远端可以是源端也可以是目标端
RemoteIP=192.168.77.100
RemoteSID=orcl
cat >>$ORACLE_HOME/network/admin/tnsnames.ora<<EOF
ASM =
 (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = $(hostname -i))(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM)
      (SID_NAME = +ASM1)
    )
  )
LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = $(hostname -i))(PORT = 1521)))
    (CONNECT_DATA =
      (SERVICE_NAME = $(echo ${ORACLE_SID}|sed 's/[0-9]//g'))))
REMOTE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ${RemoteIP})(PORT = 1521)))
    (CONNECT_DATA =
      (SERVICE_NAME = ${RemoteSID})))
EOF
# 本地是RAC，ASM标签和LOCAL标签建议使用VIP

# 测试
sqlplus sys/oracle@ASM as sysdba
show parameter name;
conn sys/oracle@LOCAL as sysdba
show parameter name;
conn sys/oracle@REMOTE as sysdba
show parameter name;
exit

4° 创建OGG使用的数据库用户ggs并赋权：

# 节点1操作
sqlplus sys/oracle@LOCAL as sysdba
create tablespace GGS datafile '+DATADG' size 50m
autoextend on next 64m maxsize 30G
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER ggs IDENTIFIED BY ggs DEFAULT TABLESPACE GGS;
GRANT CONNECT TO ggs;
GRANT ALTER ANY  TABLE TO ggs;
GRANT ALTER SESSION TO ggs;
GRANT CREATE SESSION TO ggs;
GRANT FLASHBACK ANY TABLE TO ggs;
GRANT SELECT ANY DICTIONARY TO ggs;
GRANT SELECT ANY TABLE TO ggs;
GRANT RESOURCE TO ggs;
GRANT drop ANY TABLE TO ggs;
GRANT SYSDBA TO ggs;
GRANT DBA TO ggs;
GRANT EXECUTE ANY TYPE TO ggs;
GRANT SELECT ANY TRANSACTION TO ggs;
GRANT SELECT ON DBA_CLUSTERS TO ggs;
GRANT EXECUTE ON DBMS_FLASHBACK TO ggs;
grant execute on utl_file to ggs;
exec dbms_streams_auth.grant_admin_privilege('GGS');
grant insert on system.logmnr_restart_ckpt$ to ggs;
grant update on sys.streams$_capture_process to ggs;
grant become user to ggs;
alter system set enable_goldengate_replication=true scope=both;
exit

5° 在每个节点上都打开最小附加日志：

# 节点1操作
su - oracle
sqlplus / as sysdba
select count(1) from v$transaction;
alter database force logging;
alter database add supplemental log data (primary key) columns;
alter database add supplemental log data (unique) columns;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
alter system archive log current;
-- 两节点均切日志
select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,
       SUPPLEMENTAL_LOG_DATA_UI from v$database;
-- 查看状态，3个yes
exit

6° 解压OGG安装软件：

# 节点1操作
su - oracle
cd /ggs
unzip /tmp/Oracle\ GoldenGate\ 11.2.1.0.33\ for\ Oracle\ 11g\ on\ Linux\ x86-64.zip
rm -rf O*
tar -xf fbo_ggs_Linux_x64_ora11g_64bit.tar
rm -rf fbo_ggs_Linux_x64_ora11g_64bit.tar
echo "export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib">>/home/oracle/.bash_profile
source /home/oracle/.bash_profile
# 创建运行时所需的目录
./ggsci
create subdirs
exit
echo 'GGSCHEMA ggs'>GLOBALS
chmod 640 GLOBALS

7° 配置DDL支持和SEQUENCE支持：

# 节点1操作
su - oracle
cd /ggs
# 配置DDL支持
sqlplus / as sysdba
@/ggs/marker_setup.sql
-- Enter Oracle GoldenGate schema name: ggs
@/ggs/ddl_setup.sql
-- Enter Oracle GoldenGate schema name:ggs
@/ggs/role_setup.sql
--Enter GoldenGate schema name:ggs
GRANT GGS_GGSUSER_ROLE TO ggs;
@/ggs/ddl_enable.sql
@/ggs/ddl_pin ggs
exit
# 配置SEQUENCE同步支持
sqlplus / as sysdba
@/ggs/sequence.sql
-- Please enter the name of a schema for the GoldenGate database objects:
-- ggs
exit

8° 配置ogg的mgr进程：

# 需要打通OGG两端的8000到8200端口访问权限
su - oracle
cd /ggs/dirprm
# 配置mgr管理进程的配置文件
# 使用8000端口作为管理进程监听端口
# 配置8001~8200端口作为后续进程的端口
# 需要打通源端和目标端这些端口的连通权限
cat >mgr.prm<<EOF
port 8000
DYNAMICPORTLIST 8001-8200
--AUTOSTART EXTRACT *
--AUTORESTART EXTRACT *
PURGEOLDEXTRACTS ./dirdat*/*,usecheckpoints, minkeepdays 7
LAGREPORTHOURS 1
LAGINFOMINUTES 30
LAGCRITICALMINUTES 45
EOF
# 启动管理进程，查看
cd /ggs
./ggsci
start mgr
info mgr
exit

至此，OGG预部署完成

[TOC]