11g r 单机同步sequence报错

songdeyouxiang

请帮忙看看：
2012-04-18 06:37:21  INFO    OGG-01513  Oracle GoldenGate Capture for Oracle, w1ext.prm:  Positioning to Sequence 3030, RBA 40773136, SCN 0.324146485.
2012-04-18 06:37:21  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, w1ext.prm:  Positioned to Sequence 3030, RBA 40773136, SCN 0.324146485, 2012-4-18 上午04:00:44.
2012-04-18 06:37:21  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, w1ext.prm:  EXTRACT W1EXT started.
2012-04-18 06:37:21  INFO    OGG-01056  Oracle GoldenGate Capture for Oracle, w1ext.prm:  Recovery initialization completed for target file /goldengate/trails/w1000038, at RBA 1419, CSN 323719333.
2012-04-18 06:37:21  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, w1ext.prm:  Output file /goldengate/trails/w1 is using format RELEASE 11.2.
2012-04-18 06:37:21  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, w1ext.prm:  Rolling over remote file /goldengate/trails/w1000038.
2012-04-18 06:37:21  INFO    OGG-01517  Oracle GoldenGate Capture for Oracle, w1ext.prm:  Position of first record processed Sequence 3030, RBA 40773136, SCN 0.324146485, 2012-4-18 上午04:00:44.
2012-04-18 06:40:42  ERROR   OGG-00460  Oracle GoldenGate Capture for Oracle, w1ext.prm:  Cannot find metadata property DDL_MD_TAB_SEQCACHE for object SENDER.S_SEQ1.  DDL metadata [,G4='AAAABKAABAAAAIlAAD',].
2012-04-18 06:40:42  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, w1ext.prm:  PROCESS ABENDING.

序列配置参照这个文档：
implementing replication of cyclic sequences in GoldenGateImplementing cyclic sequences:




NOTE: You must be logged in as SYSDBA to install sequence.sql

Note that steps 1-3 are required on BOTH source and target.
1. If  an OGG User for DDL replication has been created,  proceed to Step  2. Otherwise, create OGG user (say OGGADMIN). This should be the same  Oracle user used for DDL replication. Connect as SYSDBA to the Oracle  database

SQL> CREATE USER OGGADMIN IDENTIFIED BY <password>;
SQL> GRANT CONNECT,RESOURCE,DBA TO OGGADMIN;


2. Install the SQL procedures needed to support sequence replication

SQL> sequence.sql


When prompted for the user name, enter the appropriate OGG user (OGGADMIN in this case)

3. Grant appropriate privileges to GGSCI user

SQL> GRANT EXECUTE on OGGADMIN.updateSequence TO ggsciUser; (user used to
login to GGSCI)


At the Target Database:

1. Grant appropriate privileges to Oracle Golden Gate Replicat User



SQL> GRANT EXECUTE on OGGADMIN.replicateSequence TO replicateUser;


FIRST USE:
----------
Before  starting to replicate sequences,  the following steps must be  performed at the source database. . In the following steps,  assume the  extract name is EXT01

1. Connect to the source database

GGSCI> DBLOGIN userid <GGSCI-user> Password:


2. Stop Extract, if it is running

GGSCI> STOP EXTRACT EXT01


3. Start Extract with appropriate parameter file that identifies thesequences to be replicated

GGSCI> START EXTRACT EXT01


4. Flush the sequences to be replicated using FLUSH SEQUENCE command in GGSCI
Example#1: To replicate all sequences contained in schemas HR and FINANCE

GGSCI> FLUSH SEQUENCE HR.*
GGSCI> FLUSH SEQUENCE FINANCE.*


Example#2 To replicate sequences for schemas HR.SEQ1 and HR.SEQ2

GGSCI> FLUSH SEQUENCE HR.SEQ1
GGSCI> FLUSH SEQUENCE HR.SEQ2

Maclean Liu(刘相兵

请上传 完整的 ggserr.log

Maclean Liu(刘相兵

NEED MORE DIAG INFO ， specially the ogg version  

looks like  RELEASE 11.2


ODM FINDING:

OGG Extract Abend with GGS ERROR 2003 or OGG-00458 Cannot Find Metadata Property or Similar

Applies to:
Oracle GoldenGate - Version: 10.4.0.0 and later   [Release: 10.4.0 and later ]
Information in this document applies to any platform.
Goal
What causes the Oracle GoldenGate (OGG) Extract to abend with errors similar to following

1) GGS ERROR 2003 Cannot find metadata property DDL_MK_TAB_VALID.

2) ERROR OGG-00458 Cannot find metadata property DDL_MK_TAB_VALID


3)  ERROR OGG-00458 Cannot find metadata property DDL_MD_TAB_MASTEROWNER

    in case of rebuilding indexes there might be errors like following additionally (see topic 6. in the fix section then):

alter index MYSCHEMA.MYPRIMKEY_PK rebuild partition MYPART_2003
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-30511: invalid DDL operation in system triggers
ORA-06512: at line 993
ORA-30511: invalid DDL operation in system triggers


4)  ERROR OGG-00470 Wrong format of ddl property string (missing end delimiter)


5)  OGG-00458 Cannot find metadata property DDL_MD_COL_LOB_ENCRYPT

Solution
Following are the bugs that could cause this error

1. If using OGG version 10.4.x
Bug 9643886 fixes the issue. Please upgrade to OGG v10.4.0.70_001 or higher

2. If using OGG version 11.1.1.0.x
Bugs 11772297 fixes the issue. Please upgrade to OGG v11.1.1.0.29 or higher

3. This error could also happen due to multi-byte table names.
     See e.g. note 1356085.1

4. Bug 13078338 (base bug 12989410) could cause the following errors. Work-around is to disable the
recyclebin. OGG v11.1.1.1.2 has the fix.

ERROR OGG-00458 Cannot find metadata property DDL_MD_TAB_MASTEROWNER
or
ERROR OGG-00470 Wrong format of ddl property string (missing end delimiter)


5. Similar issues are described in internal bug 12810720 and could arise due to improper installation/upgrade of DDL replication setup. Here as well the workaround is to re-run DDL setup with purging RECYCLEBIN. Perform the below steps and check if the issue is still reported:

    Login as sysdba to the database

    Step 1) Run the ddl_disable script to disable the DDL trigger.

    Step 2) Run the ddl_setup script. You will be prompted for:

    -- The name of the GoldenGate schema.

    -- The installation mode: Select the INITIALSETUP mode.

    Depending on the GGS version you may also be prompted for

    -- Purge RECYCLEBIN for all users: say YES.

    Step 3) Run the ddl_enable.sql script to enable the DDL trigger.

    Step 4). In GGSCI, restart the manager and then start Extract to resume DDL capture.

    Step 5) Verify if the errors are still reported.

6. In case of rebuilding indexes with RECYCLEBIN enabled, this might happen as well. There is no fix for the related OGG bug 12568250, which will depend on the fulfillment of a internal database enhancement request -  bug 7446676 DO NOT CLEAN UP THE RECYCLE BIN AUTOMATICALLY.

    The workarounds are in this case :
    1. disable recyclebin
    2. purge recycle bin.


References
BUG:9643886 - EXTRACT ABENDS WITH THE ERROR - CANNOT FIND METADATA PROPERTY DDL_MK_TAB_VALID
BUG:11772297 - 11G EXTRACT ABENDS WITH ERROR - CANNOT FIND METADATA PROPERTY DDL_MK_TAB_VALID
NOTE:1356085.1 - OGG Support for Multibyte Character Replication is limited and varies
BUG:12568250 - ORA-30511 WHEN DDL TRIGGER IS ENABLED

songdeyouxiang

hello,这里日错误日志信息

Maclean Liu(刘相兵

1.

ogg 的版本是否是 11.2 ?

ggsci -v                                        ==》贴出该命令的输出


贴出 SENDER.S_SEQ1 的DDL 语句

2.
MOS 上目前找不到 Cannot find metadata property DDL_MD_TAB_SEQCACHE 的相关信息


advise 建议：

1. 跳过 这个 sequence 相关的DDL

2. 升级 或回退 goldengate的版本

songdeyouxiang

[oracle@localhost goldengate]$ ./ggsci -v

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.0 OGGCORE_11.2.1.0.0_PLATFORMS_120131.1910_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Feb  1 2012 00:55:59

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.



SENDER.S_SEQ1创建脚本：

-- Create sequence
create sequence SENDER.S_SEQ1
minvalue 1
maxvalue 999999999999999999999999999
start with 93029
increment by 1
cache 1500;


请问
1.我配置序列同步参照的那个文档，是正确的操作文档吗
2.在oracle下载网站只找到goldengate V11.2这个版本支持oracle 11g，还有哪个版本支持oracle 11.1.0.7.0呢
3.goldengate 目前的版本是V11.2.1.0.0 mos上有补丁吗，想想，要不试下升级下