Oracle GoldenGate and compressed tables
Oracle GoldenGate and compressed tables [ID 1266389.1]
修改時間 17-JUN-2011 型別 HOWTO 狀態 PUBLISHED
In this Document
Goal
Solution
References
Applies to:
Oracle GoldenGate - Version: 11.1.1.0.0 and later [Release: 11.1.1 and later ]
Information in this document applies to any platform.
Goal
Oracle GoldenGate and compressed tables
Solution
OGG does not support compressed tables or partitions, neither does it handle it well with proper error messages until OGG v10.4. We have several cases reported by customers when it deals with compressed tables. Sometimes it abends without any error message and sometimes with wrong messages. (ex: BugDB 10267584)
From V11.1.1.0.0, we enhanced the error handling part in BugDB 9425542, which gives meaningful error message on the compressed record before Extract abend. It will list out the table name, rowid and etc
Example :
ERROR OGG-01028 Record on table QATEST1.TAB1 with rowid AAM4EkAAEAACBguAAA from transaction 5.24.270123 (0x0005.018.00041f2b) is compressed. Compression is not supported.
However, due to bug 10063108, sometimes the error message on compressed tables are not entirely correct. This problem has been fixed in 11.1.1.0.3 and above
A table created as compressed will cause all of the DMLas to go into compressed blocks on disk. If the user does an "alter table nocompress", every DML that goes into the table AFTER that point in time will be uncompressed. The query for compression will return "nocompress" now, but that simple "alter" does not change the already existing compressed blocks on disk that were created before the "alter". So to capture the records from a table which was compressed we need to do the following
SQL> alter table move nocompress;
This will touch every single block on disk and will uncompress everything and so OGG should be all good.
Sometimes customer has partitioned tables, even though they have un-compressed partitions, as long as there is any partition that is compressed, we canat support that. This could be verified by getting the full DDL for the table by running DBMS_METADATA.GET_DDL package. KM 965696.1.In case table partitions are compressed, Please run the below query and get the partition names & tablespace names.
SQL> SELECT partition_name, subpartition_name, tablespace_name, high_value FROM user_tab_subpartitions WHERE table_name = 'table_name';
Alter statement for partition to move nocompress.
SQL> ALTER TABLE MOVE PARTITION NOCOMPRESS TABLESPACE ;
Please ensure that you are having enough disk space within tablespaces before running the ALTER statement.
We will be adding full support of compressed tables in future release, however, in current V10.4 and V11.1.1.x, the only option is to comment the compressed table or exclude them in Extract(if you canat do a "move nocompress").
Listing some scenarios in which we have seen similar errors for compression --------------------------------------------------------------------------------------
1) The extract abends with the following error
GGS ERROR ZZ-0QY Failed to validate table .. The table is compressed and extract will not be able to extract data from Oracle logs.
相關文章
- Creating Compressed Tables and IndexesIndex
- [20130831]Compressed partitions are not compressed tables.txt
- Oracle TablesOracle
- Oracle Externale TablesOracle
- Oracle - Tables/IndexesOracleIndex
- Oracle X$TablesOracle
- Oracle X$ TablesOracle
- Oracle Partitioned TablesOracle
- 【oracle】user_tablesOracle
- 常用的Oracle x$ TablesOracle
- Oracle Temporary Tables(Oracle 臨時表)Oracle
- Oracle GoldenGate DirectorOracleGo
- oracle goldengate 配置OracleGo
- 【GoldenGate】Oracle GoldenGate(三) DDL同步配置GoOracle
- Oracle SQL Loader(sqlldr)+ Externale TablesOracleSQL
- Oracle Redefining Tables OnlineOracle
- Oracle's x$ Tables -- René NyffeneggerOracle
- 【GoldenGate】Oracle GoldenGate(二) 雙向同步配置GoOracle
- About the Oracle GoldenGate TrailOracleGoAI
- oracle goldengate維護OracleGo
- Oracle GoldenGate: 使用巨集OracleGo
- GoldenGate Oracle MSSQL DateGoOracleSQL
- Oracle 12c: Recover tables using RMANOracle
- External Tables: Querying Data From Flat Files in OracleOracle
- Oracle GoldenGate安裝(一)OracleGo
- Oracle GoldenGate安裝(二)OracleGo
- Oracle GoldenGate安裝(三)OracleGo
- ORACLE GoldenGate Initial LoadOracleGo
- Oracle GoldenGate環境搭建OracleGo
- oracle goldengate 初始化OracleGo
- Oracle goldengate 安裝配置OracleGo
- oracle GoldenGate Veridata配置OracleGo
- 轉:Oracle GoldenGate VeridataOracleGo
- Oracle GoldenGate – MappingsOracleGoAPP
- GoldenGate MSSQL Oracle基本流程GoSQLOracle
- 解除安裝Oracle GoldenGateOracleGo
- Oracle GoldenGate下載地址OracleGo
- oracle goldengate日常管理命令OracleGo