xxx容灾-goldengate预实施检查脚本和报告v1

1、文档信版本号修订审核文档信版本号修订审核批准修改内Zeng初Zeng接收活动分发日项目名称X容修订人Zeng 文档版本号职位Senior Sales文档版本日期2011-06-审核人审核日期文档综文档说读者范术语说运文档综文档说读者范术语说运关于数据中表的trandata数据库中表为外键表且为cascade模数据库中所有的reversekey索1. 文档综2.据运该# su # / as sysdba full-3. 报表文件相关解05-31-2011 2.据运该# su # / as sysdba full-3. 报表文件相关解05-31-2011 1GGOracle Database 10

2、g EntriseEditionRelease10.2.0.5.0-Prod PL/SQL Release 10.2.0.5.0 - Production10.2.0.5.0 TNSforLinux:10.2.0.5.0-NLSRTL 10.2.0.5.0 :05-18-容灾_Goldengate 实施规范 v1.1.docxXLinux IA (32-格式如下：NLS_LANGUAGE_Oracle Database 10g EntriseEditionRelease10.2.0.5.0-Prod PL/SQL Release 10.2.0.5.0 - Production10.2.0.5.

3、0 TNSforLinux:10.2.0.5.0-NLSRTL 10.2.0.5.0 :05-18-容灾_Goldengate 实施规范 v1.1.docxXLinux IA (32-格式如下：NLS_LANGUAGE_NLS_TERRITORY. ( 数据库节点S11数据库文件11表压缩- COMPRESSED no -andtheirCount By 数据库文件11表压缩- COMPRESSED no -andtheirCount By 7521PACKAGE 132213211- Distinct Column ypes and their he 1711s- Tables belowO

4、racle10G)twillFailAddTrandata(Onlyan1711s- Tables belowOracle10G)twillFailAddTrandata(Onlyani he Databasee KeyorUniqueIndexbySchema: -Tables Defined with Rowsize 2M in all - Tables With No Primary Key or Unique Index and Column lenght -Tables WithCLOB,BLOB,NCLOB LONG Columns in ALL - Tables With Col

5、umns of UNSUPPORTED ypes ALL -Tables WithCLOB,BLOB,NCLOB LONG Columns in ALL - Tables With Columns of UNSUPPORTED ypes ALL - Cluster, or Object Tables - SUPPORTED - in ALL -IOT(FullysupportforOracle10GR2(withorwithoutoverflows) GGS 10.4 and higher) - in All Schemas:及contentor Context - Tables - Type

6、s of s on the Tables in ALL 18-Cascading Deletes on the Tables in ALL -Tables Defined with Triggers in ALL - Performance es - Reverse Key Indexes in ALL18-Cascading Deletes on the Tables in ALL -Tables Defined with Triggers in ALL - Performance es - Reverse Key Indexes in ALL- Sequence numbers - could be ae for HA CYCLE CACHE_SIZE 11Y111Y11YAvg Log Frequency of Log Switches by hour and 00 01 02 03 05 06 07 08 09 22 -05-0 00000040000000000000004. DDL 方面的Avg Log Frequ