1.两主机IP及主机名称规划,dg2 为下端捕获数据库:
[oracle@dg2 ~]$ hostname
dg2
[oracle@dg2 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
192.168.1.88 dg2
192.168.1.87 dg1
192.168.1.27 cc12
[oracle@dg2 ~]$ uname -a
Linux dg2 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[oracle@dg2 ~]$ arch
x86_64
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$
2.下端捕获数据库tnsnames.ora 文件配置:
添加到上游数据库连接串
[oracle@dg2 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl1)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
测试网络连通性:
[oracle@dg2 admin]$ tnsping orcl1
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:29:33
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl1)))
OK (10 msec)
[oracle@dg2 admin]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:29:36
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec)
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
3.调整上游数据库tnsnames.ora文件,添加到下游数据库的网络连接串:
[oracle@dg2 admin]$ ssh dg1
The authenticity of host 'dg1 (192.168.1.87)' can't be established.
RSA key fingerprint is 28:5d:76:19:60:ac:26:ca:3e:84:83:5e:fe:7e:51:3d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'dg1,192.168.1.87' (RSA) to the list of known hosts.
oracle@dg1's password:
[oracle@dg1 ~]$
[oracle@dg1 ~]$
[oracle@dg1 ~]$
[oracle@dg1 ~]$
[oracle@dg1 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@dg1 admin]$ vi tnsnames.ora
[oracle@dg1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl1)
)
)
[oracle@dg1 admin]$
[oracle@dg1 admin]$
[oracle@dg1 admin]$
测试网络连通性:
[oracle@dg1 admin]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:30:43
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec)
[oracle@dg1 admin]$ tnsping orcl1
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-OCT-2017 01:30:45
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl1)))
OK (10 msec)
[oracle@dg1 admin]$
4上游数据库归档模式检查:
[oracle@dg1 admin]$
[oracle@dg1 admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:30:50 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect /as sysDBA
Connected.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
5.目标端数据调整为归档模式:
[oracle@dg2 admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:31:03 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Current log sequence 6
SQL>
SQL>
SQL>
SQL>
SQL> connect /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 989858976 bytes
Database Buffers 603979776 bytes
Redo Buffers 7319552 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 4182M
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
6.调整上游数据库配置相关参数,以满足goldengate 安装要求:
[oracle@dg2 admin]$
[oracle@dg2 admin]$ sqlplus sys/oracle@orcl as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:35:04 2017
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, OLAP, Data Mining and Real Application Testing options
SQL> select database_role,log_mode,force_logging from v$database;
DATABASE_ROLE LOG_MODE FOR
---------------- ------------ ---
PRIMARY ARCHIVELOG NO
SQL> alter database force logging;
Database altered.
SQL> alter system set streams_pool_size=512M scope=both;
System altered.
SQL> alter database add supplemental log data;
Database altered.
SQL> alter system set enable_goldengate_replication = true;
System altered.
SQL> create user ogg identified by oracle account unlock;
User created.
SQL> grant resource,dba,connect to ogg identified by oracle;
Grant succeeded.
SQL> exec dbms_streams_auth.grant_admin_privilege('ogg');
PL/SQL procedure successfully completed.
SQL> grant become user to ogg;
Grant succeeded.
SQL> alter user scott identified by oracle account unlock;
User altered.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
7.调整下游数据库相关配置及参数以满足goldengate安装要求:
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$ sqlplus sys/oracle@orcl1 as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:38:32 2017
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, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select database_role,log_mode,force_logging from v$database;
DATABASE_ROLE LOG_MODE FOR
---------------- ------------ ---
PRIMARY ARCHIVELOG NO
SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;
SUPPLEME
--------
NO
SQL>
SQL>
SQL>
SQL>
SQL> create user ogg identified by oracle account unlock;
User created.
SQL> alter system set streams_pool_size=512M scope=both;
System altered.
SQL> grant resource,dba,connect to ogg identified by oracle;
Grant succeeded.
SQL> exec dbms_streams_auth.grant_admin_privilege('ogg');
PL/SQL procedure successfully completed.
SQL> grant become user to ogg;
Grant succeeded.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
8.下游数据库自身在线日志归档目录调整:
SQL>
SQL> host mkdir -p /u01/arc_dest/local
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/u01/arc_dest/local VALID_FOR=(ONLINE_LOGFILE, PRIMARY_ROLE)'
2 ;
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE
2 ;
System altered.
9.下游数据库指定上游数据库在线日志归档目录调整:
SQL> host mkdir -p /u01/arc_dest/srl_dbms1
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=/u01/arc_dest/srl_dbms1 VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcl1)';
System altered.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dg2 admin]$
[oracle@dg2 admin]$
10.上游数据库相关调整操作:
[oracle@dg2 admin]$ sqlplus sys/oracle@orcl as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 01:45:18 2017
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, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcl1)';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=ORCL1 ASYNC OPTIONAL NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl1';
System altered.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;
System altered.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
11.下游主机安装goldengate 12.2.0.1.1 软件:
[oracle@dg2 admin]$ hostname
dg2
[oracle@dg2 admin]$
[oracle@dg2 admin]$
[oracle@dg2 admin]$ mkdir -p /u01/ogg
[oracle@dg2 admin]$ cd /u01/ogg
[oracle@dg2 ogg]$ pwd
/u01/ogg
[oracle@dg2 ogg]$ ls -l
total 464468
-rw-r--r--. 1 root root 475611228 Feb 3 2016 V100692-01.zip
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$ cd
[oracle@dg2 ~]$ cat .bash_profile
# ---------------------------------------------------
# OS User: oracle
# Application: Oracle Database Software Owner
# Version: Oracle 11g release 2
# ---------------------------------------------------
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
export GGHOME=/u01/ogg
ORACLE_SID=orcl1; export ORACLE_SID #another is dgh2
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=. {JAVA_HOME}/bin {PATH} HOME/bin ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH} ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH} ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH} ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH} ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
# ---------------------------------------------------
# UMASK
# ---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the user performing
# the Oracle software installation creates files
# with 644 permissions.
# ---------------------------------------------------
umask 022
[oracle@dg2 ~]$ echo $GGHOME
[oracle@dg2 ~]$ source .bash_profile
[oracle@dg2 ~]$ echo $GGHOME
/u01/ogg
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$
[oracle@dg2 ~]$ cd $GGHOME
[oracle@dg2 ogg]$ ls -l
total 464468
-rw-r--r--. 1 root root 475611228 Feb 3 2016 V100692-01.zip
[oracle@dg2 ogg]$ unzip V100692-01.zip
Archive: V100692-01.zip
creating: fbo_ggs_Linux_x64_shiphome/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
...........中间忽略...........................
inflating: OGG-12.2.0.1-README.txt
inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf
[oracle@dg2 ogg]$ exit
logout
[root@dg2 ~]# export DISPLAY=192.168.1.1:0.0
[root@dg2 ~]# XHOST +
-bash: XHOST: command not found
[root@dg2 ~]# xhost +
access control disabled, clients can connect from any host
[root@dg2 ~]# su - oracle
[oracle@dg2 ~]$ xhost +
access control disabled, clients can connect from any host
[oracle@dg2 ~]$ ls
[oracle@dg2 ~]$ cd $GGHOME
[oracle@dg2 ogg]$ ls
fbo_ggs_Linux_x64_shiphome OGG-12.2.0.1.1-ReleaseNotes.pdf OGG-12.2.0.1-README.txt V100692-01.zip
[oracle@dg2 ogg]$ cd fbo_ggs_Linux_x64_shiphome/Disk1/
[oracle@dg2 Disk1]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 20290 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1999 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n] y
>>> Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-10-16_01-52-18AM. Please wait ...[oracle@dg2 Disk1]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2017-10-16_01-52-18AM.log
[oracle@dg2 Disk1]$
[oracle@dg2 Disk1]$
[oracle@dg2 Disk1]$
[oracle@dg2 Disk1]$
12. 确认goldnegate 软件安装正常,创建goldengate相关工作目录:
[oracle@dg2 Disk1]$ cd
[oracle@dg2 ~]$ cd $GGHOME
[oracle@dg2 ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg2) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (dg2) 2> view params mgr
PORT 7809
GGSCI (dg2) 3> create subdirs
Creating subdirectories under current directory /u01/ogg
Parameter files /u01/ogg/dirprm: already exists
Report files /u01/ogg/dirrpt: already exists
Checkpoint files /u01/ogg/dirchk: already exists
Process status files /u01/ogg/dirpcs: already exists
SQL script files /u01/ogg/dirsql: already exists
Database definitions files /u01/ogg/dirdef: already exists
Extract data files /u01/ogg/dirdat: already exists
Temporary files /u01/ogg/dirtmp: already exists
Credential store files /u01/ogg/dircrd: already exists
Masterkey wallet files /u01/ogg/dirwlt: already exists
Dump files /u01/ogg/dirdmp: already exists
GGSCI (dg2) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (dg2) 5>
GGSCI (dg2) 5>
GGSCI (dg2) 5>
GGSCI (dg2) 5> exit
13. 此时登录上游主机dg1查看数据库告警日志,发现有如下报错:
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$ ssh dg1
oracle@dg1's password:
Last login: Mon Oct 16 01:30:03 2017 from dg2
[oracle@dg1 trace]$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/trace
[oracle@dg1 trace]$ tail -20f alert_orcl.log
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'ORCL1'. Error is 16191.
Mon Oct 16 01:54:22 2017
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'ORCL1'. Error is 16191.
Mon Oct 16 01:55:23 2017
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'ORCL1'. Error is 16191.
此错误的原因为上游数据库的口令文件 $ORACLE_HOME/dbs/orapworcl未拷贝至下游数据库相关目录(记住还要rename to orapworcl1),下面为相关调整步骤:
拷贝口令文件至下游主机dg2:
[oracle@dg1 trace]$ cd $ORACLE_HOME/dbs/
-rw-r-----. 1 oracle oinstall 1536 Aug 8 2015 orapworcl
[oracle@dg1 dbs]$ scp orapworcl dg2:`pwd`
The authenticity of host 'dg2 (192.168.1.88)' can't be established.
RSA key fingerprint is 28:5d:76:19:60:ac:26:ca:3e:84:83:5e:fe:7e:51:3d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'dg2,192.168.1.88' (RSA) to the list of known hosts.
oracle@dg2's password:
orapworcl 100% 1536 1.5KB/s 00:00
[oracle@dg1 dbs]$
下游主机重命名口令文件:
[oracle@dg2 ogg]$ cd $ORACLE_HOME/dbs
[oracle@dg2 dbs]$ ls -l
total 24
-rw-rw----. 1 oracle oinstall 1544 Oct 16 01:32 hc_orcl1.dat
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 24 Oct 11 03:36 lkORCL1
-rw-r-----. 1 oracle oinstall 1536 Oct 16 01:56 orapworcl
-rw-r-----. 1 oracle oinstall 1536 Oct 11 03:38 orapworcl1
-rw-r-----. 1 oracle oinstall 3584 Oct 16 01:44 spfileorcl1.ora
[oracle@dg2 dbs]$ mv orapworcl orapworcl1
[oracle@dg2 dbs]$ ls -ltr
total 20
-rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle oinstall 24 Oct 11 03:36 lkORCL1
-rw-rw----. 1 oracle oinstall 1544 Oct 16 01:32 hc_orcl1.dat
-rw-r-----. 1 oracle oinstall 3584 Oct 16 01:44 spfileorcl1.ora
-rw-r-----. 1 oracle oinstall 1536 Oct 16 01:56 orapworcl1
14.下游主机dg2配置下端流抽取进程 ext1:
[oracle@dg2 dbs]$
[oracle@dg2 dbs]$
[oracle@dg2 dbs]$
[oracle@dg2 dbs]$ cd $GGHOME
[oracle@dg2 ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg2) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (dg2) 2> exit
[oracle@dg2 ogg]$ ggsci -v
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg2) 1> dblogin userid ogg@orcl,password oracle
Successfully logged into database.
GGSCI (dg2 as ogg@orcl) 2> miningdblogin userid ogg@orcl1,password oracle
Successfully logged into mining database.
GGSCI (dg2 as ogg@orcl) 3>
GGSCI (dg2 as ogg@orcl) 3>
GGSCI (dg2 as ogg@orcl) 3>
GGSCI (dg2 as ogg@orcl) 3> register extract ext1 database
2017-10-16 02:00:53 ERROR OGG-02060 The Oracle mining database is not configured properly to support integrated capture. The following configuration error must be fixed: Operation not supported because enable_goldengate_replication is not set to true.
此错误为 下游数据库参数enable_goldengate_replicate 参数未调整为true,调整此参数如下:
GGSCI (dg2 as ogg@orcl) 4> exit
[oracle@dg2 ogg]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:01:21 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> alter system set enable_goldengate_replication = true;
System altered.
SQL> show parameter goldengate
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
登录上游数据库,开启用户级别附件日志:
GGSCI (dg2 as ogg@orcl) 6> dblogin userid ogg@orcl,password oracle
Successfully logged into database.
GGSCI (dg2 as ogg@orcl) 7> add schematrandata scott
2017-10-16 02:07:59 INFO OGG-01788 SCHEMATRANDATA has been added on schema scott.
2017-10-16 02:07:59 INFO OGG-01976 SCHEMATRANDATA for scheduling columns has been added on schema scott.
GGSCI (dg2 as ogg@orcl) 8>
重新注册下端流集成抽取进程ext1:
[oracle@dg2 ogg]$ pwd
/u01/ogg
[oracle@dg2 ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg2) 1> dblogin userid ogg@orcl,password oracle
Successfully logged into database.
GGSCI (dg2 as ogg@orcl) 2> miningdblogin userid ogg@orcl1,password oracle
Successfully logged into mining database.
GGSCI (dg2 as ogg@orcl) 3> register extract ext1 database
2017-10-16 02:02:06 INFO OGG-02003 Extract EXT1 successfully registered with database at SCN 1015610.
编辑抽取进程参数文件:
GGSCI (dg2 as ogg@orcl) 4> edit params ext1
GGSCI (dg2 as ogg@orcl) 10> edit params ext1
extract ext1
userid ogg@orcl,password oracle
tranlogoptions mininguser ogg,miningpassword oracle
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine N)
Exttrail ./dirdat/lr
LOGALLSUPCOLS
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table scott.*;
GGSCI (dg2 as ogg@orcl) 8> ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW
EXTRACT (Integrated) added.
GGSCI (dg2 as ogg@orcl) 13> add exttrail ./dirdat/lr, extract ext1, megabytes 200
EXTTRAIL added.
GGSCI (dg2 as ogg@orcl) 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:01:59
GGSCI (dg2 as ogg@orcl) 15> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (dg2 as ogg@orcl) 33> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (dg2 as ogg@orcl) 34> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:08:59
GGSCI (dg2 as ogg@orcl) 41> view params ext1
GGSCI (dg2 as ogg@orcl) 42> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:10:10
GGSCI (dg2 as ogg@orcl) 43> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (dg2 as ogg@orcl) 44> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:10:13
GGSCI (dg2 as ogg@orcl) 45> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STARTING EXT1 00:00:00 00:10:16
GGSCI (dg2 as ogg@orcl) 46> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:10:39
GGSCI (dg2 as ogg@orcl) 47> view report ext1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 01:10:08
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
Starting at 2017-10-16 02:18:39
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue Jan 29 11:47:41 EST 2013, Release 2.6.32-358.el6.x86_64
Node: dg2
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 6317
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2017-10-16 02:18:39 INFO OGG-03059 Operating system character set identified as US-ASCII.
2017-10-16 02:18:39 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
extract ext1
userid ogg@orcl,password ***
2017-10-16 02:18:39 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
tranlogoptions mininguser ogg,miningpassword ***
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine N)
Exttrail ./dirdat/lr
LOGALLSUPCOLS
2017-10-16 02:18:39 WARNING OGG-04033 LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table scott.*;
2017-10-16 02:18:39 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:18:39 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT1.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u01/ogg
2017-10-16 02:18:39 INFO OGG-01851 filecaching started: thread ID: 140199436269312.
2017-10-16 02:18:39 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
2017-10-16 02:18:39 WARNING OGG-02045 Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:18:39 INFO OGG-02248 Logmining server DDL filtering enabled.
2017-10-16 02:18:40 INFO OGG-02068 Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:18:41 INFO OGG-02089 Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:18:41 INFO OGG-02086 Integrated Dictionary will be used.
2017-10-16 02:18:41 WARNING OGG-02901 Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead.
2017-10-16 02:18:41 WARNING OGG-02083 DDLOPTIONS with ADDTRANDATA is no longer supported.
Source Context :
SourceModule : [ggdb.ora.ddl]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/gglib/ggdbora/ddlora.c]
SourceFunction : [metadata_from_logminer]
SourceLine : [971]
ThreadBacktrace : [14] elements
: [/u01/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f82c3246f1b]]
: [/u01/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f82c32410a4]]
: [/u01/ogg/libgglog.so(_MSG_ERR_INTEGRATED_DICT_MISSING_PATCH(CSourceContext*, CMessageFactory::MessageDisposition)+0x29) [0x7f82c3211965]]
: [/u01/ogg/extract(metadata_from_logminer(ggs::gglib::ggunicode::UString const*, unsigned long, unsigned int, unsigned int, ggs::gglib::ggunicode::UString const&, bool, DD
LPropertyBuffer&, bool)+0x2b44) [0x6fdba4]]
: [/u01/ogg/extract() [0x76204f]]
: [/u01/ogg/extract(REDO_validate_config(bool, unsigned int*, bool&)+0x72e) [0x7687ee]]
: [/u01/ogg/extract(ggs::er::OraTranLogDataSource::setup()+0x6c) [0x75bd2c]]
: [/u01/ogg/extract() [0x5f3c56]]
: [/u01/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d05b0]]
: [/u01/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6d179d]]
: [/u01/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d1881]]
: [/u01/ogg/extract(main+0x3b) [0x5f50eb]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x33e281ecdd]]
: [/u01/ogg/extract() [0x563159]]
2017-10-16 02:18:41 ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
2017-10-16 02:18:41 ERROR OGG-01668 PROCESS ABENDING.
此错误为下游数据库未打必要的补丁导致的:
上传接下相关补丁:
GGSCI (dg2 as ogg@orcl) 50> exit
[oracle@dg2 ogg]$ cd
[oracle@dg2 ~]$ ls
p17030189_112040_Generic.zip
[oracle@dg2 ~]$ unzip p17030189_112040_Generic.zip
Archive: p17030189_112040_Generic.zip
creating: 17030189/
inflating: 17030189/postdeinstall.sql
creating: 17030189/etc/
creating: 17030189/etc/config/
inflating: 17030189/etc/config/inventory.xml
inflating: 17030189/etc/config/deploy.xml
inflating: 17030189/etc/config/actions.xml
creating: 17030189/etc/xml/
inflating: 17030189/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 17030189/etc/xml/GenericActions.xml
creating: 17030189/files/
creating: 17030189/files/sqlpatch/
creating: 17030189/files/sqlpatch/17030189/
inflating: 17030189/files/sqlpatch/17030189/postdeinstall.sql
inflating: 17030189/files/sqlpatch/17030189/postinstall.sql
creating: 17030189/files/rdbms/
creating: 17030189/files/rdbms/admin/
inflating: 17030189/files/rdbms/admin/prvtlmcb.plb
inflating: 17030189/README.txt
inflating: 17030189/postinstall.sql
inflating: PatchSearch.xml
关闭下游数据库,准备打补丁:
[oracle@dg2 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:21:21 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dg2 ~]$ ls -l
total 68
drwxrwxr-x. 4 oracle oinstall 4096 May 26 2015 17030189
-rw-r--r--. 1 root root 57558 Mar 3 2016 p17030189_112040_Generic.zip
-rw-rw-r--. 1 oracle oinstall 2344 May 26 2015 PatchSearch.xml
[oracle@dg2 17030189]$ pwd
/home/oracle/17030189
[oracle@dg2 17030189]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/17030189_Oct_16_2017_02_23_51/apply2017-10-16_02-23-50AM_1.log
Applying interim patch '17030189' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Verifying the update...
Patch 17030189 successfully applied
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/17030189_Oct_16_2017_02_23_51/apply2017-10-16_02-23-50AM_1.log
OPatch succeeded.
开启下游数据库并执行后继步骤,执行相关sql 脚本:
[oracle@dg2 17030189]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:30:17 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> @postinstall.sql
.......中间内容略..........
PL/SQL procedure successfully completed.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
下游主机登录 ggsci 并重新启动下游抽取进程ext1:
[oracle@dg2 17030189]$ cd $GGHOME
[oracle@dg2 ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg2) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:22:46
GGSCI (dg2) 2> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
GGSCI (dg2) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:22:51 00:00:01
GGSCI (dg2) 5> view ggsevt
2017-10-16 01:54:18 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): CREATE SUBDIRS.
2017-10-16 01:54:19 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): START MGR.
2017-10-16 01:54:19 WARNING OGG-01877 Oracle GoldenGate Manager for Oracle, mgr.prm: Missing explicit accessrule for server collector.
2017-10-16 01:54:19 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2017-10-16 01:54:19 INFO OGG-00983 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started (port 7809).
2017-10-16 01:54:20 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle, oby.oby: GGSCI command (oracle): CREATE DATASTORE.
2017-10-16 01:55:03 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 01:55:12 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): create subdirs.
2017-10-16 01:55:16 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 01:59:45 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:00:13 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid ogg@orcl password ***.
2017-10-16 02:00:31 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): miningdblogin userid ogg@orcl1 password ***.
2017-10-16 02:00:53 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): register extract ext1 database.
2017-10-16 02:00:53 ERROR OGG-02060 Oracle GoldenGate Command Interpreter for Oracle: The Oracle mining database is not configured properly to support integrated capture. The following configur
ation error must be fixed: Operation not supported because enable_goldengate_replication is not set to true.
2017-10-16 02:01:48 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid ogg@orcl password ***.
2017-10-16 02:01:54 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): miningdblogin userid ogg@orcl1 password ***.
2017-10-16 02:01:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): register extract ext1 database.
2017-10-16 02:02:06 INFO OGG-02003 Oracle GoldenGate Command Interpreter for Oracle: Extract EXT1 successfully registered with database at SCN 1015610.
2017-10-16 02:02:48 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2017-10-16 02:07:54 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): dblogin userid ogg@orcl password ***.
2017-10-16 02:07:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add schematrandata scott.
2017-10-16 02:07:59 INFO OGG-01788 Oracle GoldenGate Command Interpreter for Oracle: SCHEMATRANDATA has been added on schema scott.
2017-10-16 02:07:59 INFO OGG-01976 Oracle GoldenGate Command Interpreter for Oracle: SCHEMATRANDATA for scheduling columns has been added on schema scott.
2017-10-16 02:08:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW.
2017-10-16 02:08:51 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2017-10-16 02:09:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:10:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): add exttrail ./dirdat/lr extract ext1, megabytes 200.
2017-10-16 02:10:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:10:29 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:10:29 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48521 (START EXTRACT EXT1 ).
2017-10-16 02:10:29 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:10:29 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:10:29 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:10:29 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:10:29 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:10:29 ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parsing error, parameter [tranlogoptions] has unrecognized keyword or extra value "oracle"
.
2017-10-16 02:10:29 ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parsing error, parameter [tranlogoptions] has unrecognized keyword or extra value "passwor
d".
2017-10-16 02:10:29 ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parsing error, parameter [tranlogoptions] has unrecognized keyword or extra value "ogg@orc
l1".
2017-10-16 02:10:29 ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parsing error, parameter [tranlogoptions] has unrecognized keyword or extra value "userid"
.
2017-10-16 02:10:29 ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parsing error, parameter [tranlogoptions] has unrecognized keyword or extra value "miningd
blogin".
2017-10-16 02:10:29 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2017-10-16 02:10:31 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:10:33 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:11:59 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2017-10-16 02:12:49 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:12:49 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48559 (START EXTRACT EXT1 ).
2017-10-16 02:12:49 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:12:49 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:12:49 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:12:49 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:12:49 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:12:49 WARNING OGG-10143 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parameter [miningdblogin] is unrecognized and will be ignored. No parameter definition wi
th that name could be found.
2017-10-16 02:12:49 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:12:49 ERROR OGG-00303 Oracle GoldenGate Capture for Oracle, ext1.prm: Unrecognized parameter (miningdblogin).
2017-10-16 02:12:49 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2017-10-16 02:12:50 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:15:18 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2017-10-16 02:16:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:16:07 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48612 (START EXTRACT EXT1 ).
2017-10-16 02:16:07 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:16:07 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:16:07 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:16:07 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:16:07 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:16:07 ERROR OGG-10152 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parsing error, option [mininguser] for parameter [tranlogoptions] has unrecognized value "
oracle".
2017-10-16 02:16:07 ERROR OGG-10152 Oracle GoldenGate Capture for Oracle, ext1.prm: (ext1.prm) line 3: Parsing error, option [mininguser] for parameter [tranlogoptions] has unrecognized value "
password".
2017-10-16 02:16:07 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2017-10-16 02:16:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:17:07 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2017-10-16 02:17:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:17:24 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48634 (START EXTRACT EXT1 ).
2017-10-16 02:17:24 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:17:24 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:17:24 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:17:24 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:17:24 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:17:24 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:17:24 WARNING OGG-04033 Oracle GoldenGate Capture for Oracle, ext1.prm: LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:17:24 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:17:25 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT1.
2017-10-16 02:17:25 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 139880133555968.
2017-10-16 02:17:25 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
2017-10-16 02:17:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:17:28 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:17:29 ERROR OGG-02032 Oracle GoldenGate Capture for Oracle, ext1.prm: Failed to set TRANLOGOPTIONS INTEGRATEDPARAMS (DOWNSTREAM_REAL_TIME_MINE, Y).
2017-10-16 02:17:29 ERROR OGG-02042 Oracle GoldenGate Capture for Oracle, ext1.prm: OCI Error 26761.
2017-10-16 02:17:29 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2017-10-16 02:17:45 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:18:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:18:21 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params ext1.
2017-10-16 02:18:37 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:18:38 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:18:38 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48656 (START EXTRACT EXT1 ).
2017-10-16 02:18:38 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:18:38 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:18:39 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:18:39 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:18:39 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:18:39 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:18:39 WARNING OGG-04033 Oracle GoldenGate Capture for Oracle, ext1.prm: LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:18:39 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:18:39 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT1.
2017-10-16 02:18:39 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 140199436269312.
2017-10-16 02:18:39 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
2017-10-16 02:18:39 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, ext1.prm: Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:18:39 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server DDL filtering enabled.
2017-10-16 02:18:40 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:18:40 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:18:41 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:18:41 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated Dictionary will be used.
2017-10-16 02:18:41 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, ext1.prm: Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:18:41 WARNING OGG-02083 Oracle GoldenGate Capture for Oracle, ext1.prm: DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:18:41 ERROR OGG-02912 Oracle GoldenGate Capture for Oracle, ext1.prm: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
2017-10-16 02:18:41 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2017-10-16 02:18:43 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:19:06 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:19:46 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:20:31 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:24:49 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:24:52 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:24:52 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48758 (START EXTRACT EXT1 ).
2017-10-16 02:24:52 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:24:52 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:24:52 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:24:52 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:24:52 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:24:52 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:24:52 WARNING OGG-04033 Oracle GoldenGate Capture for Oracle, ext1.prm: LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:24:52 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:24:52 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT1.
2017-10-16 02:24:52 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 140685021243136.
2017-10-16 02:24:52 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
2017-10-16 02:24:53 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, ext1.prm: Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:24:53 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server DDL filtering enabled.
2017-10-16 02:24:54 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:24:54 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:24:54 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:24:54 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated Dictionary will be used.
2017-10-16 02:24:54 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, ext1.prm: Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:24:54 WARNING OGG-02083 Oracle GoldenGate Capture for Oracle, ext1.prm: DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:24:55 ERROR OGG-02912 Oracle GoldenGate Capture for Oracle, ext1.prm: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
2017-10-16 02:24:55 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2017-10-16 02:25:12 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:27:36 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:27:39 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:27:39 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48807 (START EXTRACT EXT1 ).
2017-10-16 02:27:39 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:27:39 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:27:39 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:27:39 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:27:39 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:27:40 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:27:40 WARNING OGG-04033 Oracle GoldenGate Capture for Oracle, ext1.prm: LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:27:40 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:27:40 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT1.
2017-10-16 02:27:40 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 140525671798528.
2017-10-16 02:27:40 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
2017-10-16 02:27:40 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, ext1.prm: Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:27:40 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server DDL filtering enabled.
2017-10-16 02:27:41 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:27:41 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:27:41 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated Dictionary will be used.
2017-10-16 02:27:41 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, ext1.prm: Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:27:41 WARNING OGG-02083 Oracle GoldenGate Capture for Oracle, ext1.prm: DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:27:41 ERROR OGG-02912 Oracle GoldenGate Capture for Oracle, ext1.prm: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
2017-10-16 02:27:41 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2017-10-16 02:27:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:28:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:31:13 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2017-10-16 02:31:15 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2017-10-16 02:31:15 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.1.88]:48866 (START EXTRACT EXT1 ).
2017-10-16 02:31:15 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #5).
2017-10-16 02:31:15 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2017-10-16 02:31:15 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2017-10-16 02:31:15 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as US-ASCII.
2017-10-16 02:31:15 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, ext1.prm: ANSI SQL parameter syntax is used for parameter parsing.
2017-10-16 02:31:16 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, ext1.prm: Setting session time zone to source database time zone 'GMT'.
2017-10-16 02:31:16 WARNING OGG-04033 Oracle GoldenGate Capture for Oracle, ext1.prm: LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2017-10-16 02:31:16 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-10-16 02:31:16 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/BR/EXT1.
2017-10-16 02:31:16 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ext1.prm: filecaching started: thread ID: 140002868037376.
2017-10-16 02:31:16 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ogg/dirtmp.
2017-10-16 02:31:16 WARNING OGG-02045 Oracle GoldenGate Capture for Oracle, ext1.prm: Database does not have streams_pool_size initialization parameter configured.
2017-10-16 02:31:16 INFO OGG-02248 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server DDL filtering enabled.
2017-10-16 02:31:17 INFO OGG-02068 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$CAP_EXT1 using OGGCapture API.
2017-10-16 02:31:17 INFO OGG-02089 Oracle GoldenGate Capture for Oracle, ext1.prm: Source redo compatibility version is: 11.2.0.4.0.
2017-10-16 02:31:17 INFO OGG-02086 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated Dictionary will be used.
2017-10-16 02:31:17 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, ext1.prm: Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting.
Using fetch instead.
2017-10-16 02:31:17 WARNING OGG-02083 Oracle GoldenGate Capture for Oracle, ext1.prm: DDLOPTIONS with ADDTRANDATA is no longer supported.
2017-10-16 02:31:17 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2017-10-16 02:31:17 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file ./dirdat/lr000000000, at RBA 0 (file not opened).
2017-10-16 02:31:17 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file ./dirdat/lr is using format RELEASE 12.2.
2017-10-16 02:31:18 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
下游抽取进程ext1正常启动:
GGSCI (dg2) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:04:46 00:00:01
此时上游数据库未执行DML DDL 操作,ext1 抽取进程未捕获相关事务:
GGSCI (dg2) 7>
GGSCI (dg2) 7>
GGSCI (dg2) 7>
GGSCI (dg2) 7> stats ext1
Sending STATS request to EXTRACT EXT1 ...
No active extraction maps
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 0.00
Mapped operations 0.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
.
GGSCI (dg2) 8>
GGSCI (dg2) 8>
GGSCI (dg2) 8>
GGSCI (dg2) 8> exit
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
登录上游数据库被复制用户scott,执行 ddl dml 操作并提交,并执行
alter system switch logfile命令,使归档日志传送到下有数据库
log_archive_dest_2 目录以使ext1抽取相关操作:
[oracle@dg2 ogg]$ sqlplus scott/oracle@orcl
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 16 02:32:26 2017
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, OLAP, Data Mining and Real Application Testing options
SQL> select tname from tab;
TNAME
------------------------------
BONUS
DEPT
EMP
SALGRADE
SQL> create table ttt as select * from user_objects;
Table created.
SQL> select tname from tab;
TNAME
------------------------------
BONUS
DEPT
EMP
SALGRADE
TTT
SQL> delete from emp;
14 rows deleted.
SQL> commit;
Commit complete.
SQL> alter system switch logfile;
/
/
/
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dg2 ogg]$
下游主机dg2登录ggsci,验证相关操作被正常抽取:
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$
[oracle@dg2 ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg2) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:05:56 00:00:05
GGSCI (dg2) 2> stats ext1
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2017-10-16 02:36:58.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 1.00
Mapped operations 1.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Output to ./dirdat/lr:
Extracting from SCOTT.EMP to SCOTT.EMP:
*** Total statistics since 2017-10-16 02:36:28 ***
Total inserts 0.00
Total updates 0.00
Total deletes 14.00
Total discards 0.00
Total operations 14.00
*** Daily statistics since 2017-10-16 02:36:28 ***
Total inserts 0.00
Total updates 0.00
Total deletes 14.00
Total discards 0.00
Total operations 14.00
*** Hourly statistics since 2017-10-16 02:36:28 ***
Total inserts 0.00
Total updates 0.00
Total deletes 14.00
Total discards 0.00
Total operations 14.00
*** Latest statistics since 2017-10-16 02:36:28 ***
Total inserts 0.00
Total updates 0.00
Total deletes 14.00
Total discards 0.00
Total operations 14.00
End of Statistics.
GGSCI (dg2) 3>
告警1:
2017-10-16 02:18:39 WARNING OGG-02045 Database does not have streams_pool_size initialization parameter configured.
处理:
上游及下游数据库设置streams_pool_size 参数大小
alter system set streams_pool_size=512M scope=both;
告警2:
2017-10-16 02:18:41 WARNING OGG-02901 Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead.
处理:
忽略
告警3:
2017-10-16 02:18:41 WARNING OGG-02083 DDLOPTIONS with ADDTRANDATA is no longer supported.
处理:
注销相关行
GGSCI (dg2 as ogg@orcl) 10> edit params ext1
extract ext1
userid ogg@orcl,password oracle
tranlogoptions mininguser ogg,miningpassword oracle
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine N)
Exttrail ./dirdat/lr
LOGALLSUPCOLS
----DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
UPDATERECORDFORMAT COMPACT
table scott.*; |
|