Oracle Goldengate OGG 11g与各操作系统及数据库版本的兼容列表

Oracle Goldengate OGG 11g (11.1.1.0.0)与各操作系统及数据库版本的兼容列表如下,仅供参考:

 

Oracle GoldenGate Certification Matrix 11.1.1.0.0
Version Supported Processor Type OS Version OS
32/64 bit
Oracle FM
32/64 bit
JDK Vendor
Version*
JDK
32/64 bit
Oracle
Database*
Exceptions and Additional Information
11gR1 (11.1.1.1+) x86 Red Hat EL 4 (UL7+) 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
MySQL 5.0 supports Delivery only
11gR1 (11.1.1.1+) x86 Red Hat EL 5 (UL3+) 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
MySQL 5.0 supports Delivery only
11.1.1.0.0 x86 SLES 10 (SP1+) 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
MySQL 5.0 supports Delivery only
11.1.1.0.0 x86 Windows 2003 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13
MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x86 Windows XP Professional with SP3+ 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13
MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x64 Red Hat EL 4 (UL7+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13

11.1.1.0.0 x64 Red Hat EL 5 (UL3+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
Teradata 12
Teradata 13

11.1.1.0.0 x64 SLES 10 (SP1+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13
MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x64 Windows 2003 with SP2/R2+ 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13
MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x64 Windows Server 2008 with SP1+ 64 NA NA NA Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008

11.1.1.0.0 Itanium-2 Windows Server 2008 with SP1+ 64 NA NA NA Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008

11.1.1.0.0 SPARC Solaris 2.9 Update 9+ 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15

11.1.1.0.0 SPARC Solaris 10 Update 4+ 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15

11.1.1.0.0 PA-RISC HP-UX 11i (11.23)
B.11.23.0703.059a Base Quality Pack Bundle for HP-UX 11i v2, March 2007+
64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15

11.1.1.0.0 PA-RISC HP-UX 11i (11.31)
B.11.31.0803.318a Base Quality Pack Bundle for HP-UX 11i v3, March 2008+
64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15

11.1.1.0.0 Itanium-2 HP-UX 11i (11.23)
B.11.23.0703.059a Base Quality Pack Bundle for HP-UX 11i v2, March 2007+
64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7

11.1.1.0.0 POWER AIX 5.3 (TL8+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15

11.1.1.0.0 POWER AIX 6.1 (TL2+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15

OGG常见初始化方案

数据初始化

RMAN初始化方案

本方案在初始化过程中,不需要源数据库停机。

步骤如下:

生产端===============================================

1)        源端和目标端安装OGG软件,并启动manager

2)        源端配置OGG的Extract及DataPump

3)      源端启动Extract进程,并且人工记录抽取进程启动的时间点,例如:“2011-05-03 11:20:55” ,将此时间点作为在下一步中查找长事务的一个判断条件;可以在数据库中查询该时间点:”select to_char(sysdate,’yyyy-mm-dd hh24:mi:ss’) from dual”

4)        长事务处理:在V$TRANSACTION中查找当前正在运行的事务(RAC环境下,查看gv$transaction),并找出相应的长事务。在执行rman备份之前,确保这些长事务已经完成,或者被kill掉(需要得到dba或者相关管理人员的确认)。

Select  start_time  from gv$transaction where to_date(start_time, ‘yyyy-mm-dd hh24:mi:ss’)<to_date(‘2011-05-03 11:20:55’, ‘yyyy-mm-dd hh24:mi:ss’);

注:通过上面的SQL语句查找到比第3歩中记录下的时间点早的事务,需要等到该事务结束,然后执行rman的备份;

 

 

5)        使用oracle用户登录,执行rman备份

–备份数据库:

$rman target /

run {

allocate channel ch00 type disk maxpiecesize 20g;

allocate channel ch01 type disk maxpiecesize 20g;

crosscheck backupset;

delete noprompt expired backupset;

sql ‘alter system archive log current’;

backup as backupset skip inaccessible tag hot_db_bk_level0

full database

format ‘/u01/backup/bk_%s_%p_%t’;

release channel ch00;

release channel ch01;

}

–备份归档和控制文件:(如果有三个日志文件组,可以按照以下方式进行切换,如果更多,则对应增加切换的次数即可);

run {

ALLOCATE CHANNEL ch00 TYPE DISK MAXPIECESIZE 20G;

ALLOCATE CHANNEL ch01 TYPE DISK MAXPIECESIZE 20G;

sql ‘alter system switch logfile’;

sql ‘alter system switch logfile’;

sql ‘alter system switch logfile’;

sql ‘alter system archive log current’;

BACKUP ARCHIVELOG ALL FORMAT ‘/u01/backup/ARCH_%U’;

BACKUP CURRENT CONTROLFILE FORMAT ‘/u01/backup/bk_controlfile’;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

}

在源机执行

SQL>set linesize 200

SQL>select * from Gv$log;

GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM

———- ———- ———- ———- ———- — —————- ————- ———

         1          1         23  104857600          1 NO  CURRENT                 218512 01-DEC-10

         2          1         22  104857600          1 YES ACTIVE                  218422 01-DEC-10

         3          2         17  104857600          1 NO  CURRENT                 218503 01-DEC-10

         4          2         16  104857600          1 YES INACTIVE                218412 01-DEC-10 (*)

 

获取不活动的已归档日志的最后一个SCN号,如果有多个已归档的INACTIVE的组,取最大的FIRST_CHANGE#,这里取218412

记录该SCN号(在“第10歩”目标端恢复数据库时使用),将备份文件,FTP到目标机

========================================

hpux2:/u01/oracle$ ftp 192.168.1.27

Connected to 192.168.1.27.

220 hpux_dr FTP server (Revision 4.0 Version wuftpd-2.6.1 Wed Jun 18 07:11:14 GMT 2008) ready.

Name (192.168.1.27:oracle): oracle

331 Password required for oracle.

Password:

230 User oracle logged in.

Remote system type is UNIX.

Using binary mode to transfer files.

ftp> cd /u01/oracle/rmanbk

250 CWD command successful.

ftp> lcd /u01/oracle/rmanbk

Local directory now /u01/oracle/rmanbk

ftp> bin

200 Type set to I.

ftp> prompt

Interactive mode off.

ftp> mput hp*

 

容灾端===============================================

6)        使用oracle用户登录目标机执行恢复

ü  在目标机建立相同的目录结构,并正确设置:ORACLE_BASE,ORACLE_HOME,ORACLE_SID环境变量。

ü  拷贝源机init{ORACLE_SID}.ora文件到目标机

ü  cp $ORACLE_HOME/dbs/initorcl.ora  目标机对应目录

ü  生成口令文件或者copy $ORACLE_HOME/dbs/PWD{ORACLE_SID}

 

7)        启动数据库到nomount状态

sqlplus ‘/ as sysdba’

SQL>startup nomount

 

8)        启动RMAN恢复控制文件

rman target /

RMAN>restore controlfile from ‘/u01/oracle/rmanbk/hpdb_ctlfile_757366280381.dbf’;

 

9)        将数据库更改为mount状态

sqlplus ‘/ as sysdba’

SQL>alter database mount;

 

10)     启动RMAN恢复数据库

rman target /

RMAN>restore database;

 

RMAN>

run

{

   set archivelog destination to ‘/u01/arch’;

   SET UNTIL SCN 218412;     –在第5歩源端记录下的scn号

   RECOVER DATABASE;

}

 

11)     使用以下SQL语句查找目标端数据库的SCN号:(得到该SCN号之后,在2.5.8章节中启动复制进程时,使用该SCN号。)

SQL> SELECT CHECKPOINT_CHANGE#,CHECKPOINT_TIME FROM V$DATAFILE_HEADER;

 

CHECKPOINT_CHANGE# CHECKPOIN

—————— ———

            218412 28-MAY-11

            218412 28-MAY-11

            218412 28-MAY-11

            218412 28-MAY-11

            218412 28-MAY-11

注:

a)  如果目标端数据库在“第10歩”操作之后,又额外追加了源数据库rman备份后的归档日志,导致目标端数据库的SCN号大于“第10歩”中SCN号。所以必须以目标端数据库当前的SCN为主,从而避免数据重复。

b)  如果目标端数据库在“第10歩”操作之后,没有额外追加源数据库rman备份后的归档日志,则“第11歩”中得到的SCN号应该与“第10歩”中的SCN号相等;

12)     (备选)如果源端为RAC,目标端为单机,需将目标机改为单机模式

删除多余的redolog group

SQL> select THREAD#, STATUS, ENABLED from v$thread;

 THREAD# STATUS ENABLED

———- —— ——–

1 OPEN   PUBLIC

2 CLOSED PRIVATE

 

SQL> select group# from v$log where THREAD#=2;

GROUP#

———-

4

5

6

 

SQL> alter database disable thread 2;

Database altered.

SQL> alter database drop logfile group 4;

alter database drop logfile group 4

ERROR at line 1:

ORA-00350: log 4 of instance racdb2 (thread 2) needs to be archived

ORA-00312: online log 4 thread 2: ‘/u01/oracle/oradata/ractest/log/redo04.log’

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.

SQL> alter database drop logfile group 5;

Database altered.

 

SQL> alter database drop logfile group 6;

 

Database altered.

SQL> select THREAD#, STATUS, ENABLED from v$thread;

 

THREAD# STATUS ENABLED

———- —— ——–

1 OPEN   PUBLIC

 

 

删除多余UNDO表空间

SQL> show parameter undo;

NAME                                 TYPE        VALUE

———————————— ———– ——————————

undo_management                   string      AUTO

undo_retention                       integer     900

undo_tablespace                      string      UNDOTBS1

 

SQL> select tablespace_name from dba_tablespaces where contents=’UNDO’;

TABLESPACE_NAME

——————————

UNDOTBS1

UNDOTBS2

SQL> drop tablespace UNDOTBS2 including contents and datafiles;

Tablespace dropped.

 

如果源数据库为Oracle9i,因为RMAN时不备份TEMP表空间,需重新创建TEMP表空间

SQL> create temporary tablespace TEMP  tempfile ‘/u01/temp.dbf’ size 500M;

Tablespace created.

SQL> alter database default temporary tablespace TEMP;

Database altered.

13)     目标端打开数据库

alter database open resetlogs;

注意:由于此时源端和目标端一样,所以要先删除DDL那几个脚本,删除replicat进程再 重新添加,最后才能 start replicat repea,aftercsn <>

Oracle EXPDP/IMPDP初始化方案

在数据初始化的过程中,不需要源数据库停机。

1)        源端和目标端安装OGG软件,并启动manager

2)        源端配置OGG的Extract及DataPump

3)        源端启动Extract进程以及DataPump进程,并且人工记录抽取进程启动的时间点,例如:“2011-05-03 11:20:55” ,将此时间点作为在下一步中查找长事务的一个判断条件;

4)        长事务处理:在V$TRANSACTION中查找当前正在运行的事务(RAC环境下,查看gv$transaction),并找出相应的长事务。在执行rman备份之前,确保这些长事务已经完成,或者被kill掉(需要得到dba或者相关管理人员的确认)。

Select  start_time  from gv$transaction where to_date(start_time, ‘yyyy-mm-dd hh24:mi:ss’)<to_date(‘2011-05-03 11:20:55’, ‘yyyy-mm-dd hh24:mi:ss’);

注:通过上面的SQL语句查找到比第3歩中记录下的时间点早的事务,需要等到该事务结束,然后执行rman的备份;

5)        创建directory用于执行数据泵操作

–directory path for store dump file

CREATE OR REPLACE DIRECTORY DATA_PUMP AS ‘E:\OGG\data’;

grant read ,write on DIRECTORY DATA_PUMP to ggs ;

–users to execute expdp

grant read ,write on DIRECTORY DATA_PUMP to maclean ;

6)        源端获取数据库当前的SCN

SQL> select dbms_flashback.get_system_change_number from dual;

 

GET_SYSTEM_CHANGE_NUMBER

————————

                 3079975

7)        源端数据导出

在源端OS系统中执行数据导出,导出用户名、dmp文件名自行修改,导出完成后ftp至目标端datapump目录

expdp maclean/maclean directory=DATA_PUMP dumpfile=<dp_maclean.dmp> flashback_scn=<scn>

 

–以下操作在目标端执行

8)        创建directory用于执行数据泵操作,同时给ggs以及导入用户赋权

–directory path for store dump file

CREATE OR REPLACE DIRECTORY DATA_PUMP AS ‘/goldengate/data’;

grant read ,write on DIRECTORY DATA_PUMP to ggs ;

grant read ,write on DIRECTORY DATA_PUMP to maclean;

9)        目标端导入数据

— 以下操作在OS中执行,具体用户名与导入dmp文件名视具体情况而定

impdp maclean/maclean DUMPFILE=DATA_PUMP:DP_maclean.DMP

 

 

Goldengate OGG常见问题与错误列表

以下列出了OGG一些常见的问题与错误及其解答:

Note: 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables’ Replication?
Note: 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note: 972954.1 What Causes The ‘Bad Column Index(xxxx)’ Error In Replicat?
Note: 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed
Note: 1112506.1 GoldenGate Extract Abends with “Unable to lock file” Error For Trail File
Note: 1124403.1 When Replicat is Running but Not Applying Records
Note: 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note: 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note: 1266389.1 Oracle GoldenGate and compressed tables
Note: 1270168.1 OGG-01028 Compression Not Supported – when extract processes regular and cluster tables
Note: 1276538.1 Replicat abending with missing key cols
Note: 1280584.1 Where To Find The List Of Supported And Unsupported Oracle Data Types for GoldenGate
Note: 1288562.1 GG Data Pumps Error With OGG-01031 When Upgrading the Target Side
Note: 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note: 1271578.1 How to Handle Tables without Primary Keys or Unique Indexes with Oracle GoldenGate
Note: 957053.1 Recovering From a GG Pump Process Abending With An Incompatible Record Error
Note: 968622.1 Does GoldenGate Support Tables With An UNUSED Column?
Note: 968614.1 Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
Note: 968769.1 GoldenGate Errors That Occur In Teradata Extract Setting
Note: 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note: 964709.1 How To Handle Oracle DDLs (add/drop/resize a Column) 22 19 1
Note: 1300076.1 Usage and considerations for allocation of ports and DYNAMICPORTLIST
Note: 1232303.1 mount options to use when configuring GoldenGate to run on NFS mounted file system
Note: 1298548.1 Extract not accepting CACHESIZE settings
Note: 1300197.1 Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
Note: 1273285.1 How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue
Note: 965356.1 GGS Error 150: No Dynamic Ports Available
Note: 1199561.1 Characterset Conversion: Error 160 Bad column length
Note: 1159684.1 Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
Note: 1292874.1 GoldenGate Extract Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
Note: 1271522.1 Oracle GoldenGate (OGG) 11.1>>> .1>>> .0 and Transparent Data Encryption (TDE)
Note: 965270.1 How does the Manager Allocate TCPIP Ports?
Note: 1195995.1 Implementing GoldenGate for DataGuard fail overs
Note: 965373.1 Installing And Configuring GoldenGate In An Oracle RAC Environment
Note: 1276058.1 Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
Note: 971264.1 How To Upgrade GGS Objects In A DDL Replication Environment
Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed

Note 969550.1 Using SCN To Do The Initial Load From Oracle To Oracle Database
Note 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables’ Replication?
Note 1235986.1 Does Oracle Goldengate extract support distributed transactions?
Note 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note 972954.1 What Causes The ‘Bad Column Index(xxxx)’; Error In Replicat?
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
Note 1112325.1 Deploying OGG to Achieve Operational Reporting for Oracle E-Business Suite
Note 1112506.1 GoldenGate Extract Abends with “Unable to lock file” Error For Trail File
Note 1120793.1 How to Get More Information than from Just a Trace on LINUX Boxes for GoldenGate
Note 1124403.1 When Replicat is Running but Not Applying Records
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 1266389.1 Oracle GoldenGate and compressed tables
Note 1270168.1 OGG-01028 Compression Not Supported – when extract processes regular and cluster tables
Note 1272645.1 Maintaining the OGG Marker table
Note 1276058.1 Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
Note 1276538.1 Replicat abending with missing key cols
Note 1280584.1 Where To Find The List Of Supported And Unsupported Oracle Data Types for GoldenGate
Note 1288562.1 GG Data Pumps Error With OGG-01031 When Upgrading the Target Side

 

沪ICP备14014813号

沪公网安备 31010802001379号