CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Gathering Information About the CDC Environment

To prepare for implementation, gather information about your Oracle CDC environment.

Ask your Oracle DBAs the following questions:

What is the Oracle database name?: Answer:
For which Oracle tables do you need to capture change data?: Answer:
Do any of the Oracle objects that will be involved in CDC conflict with PowerExchange Express CDC for Oracle restrictions?: Answer:
Is ARCHIVELOG mode and minimal global supplemental logging enabled for the Oracle source database? If not, can they be enabled?: Answer:
Do you have read access to the redo logs in your environment?: Answer:
If you do not have the authority to read the redo logs directly, can the archived redo log files be copied to a file system from which you can access them?: Answer:
Can you create a new Oracle user with the privileges that PowerExchange Express CDC for Oracle requires? What user name do you want to use?: Answer:
Are the redo logs in ASM-managed storage? If you plan to connect to an ASM instance to read redo logs, are you allowed to create a login user ID for ASM that has SYSDBA or SYSASM authority?: You must be able to connect to an ASM instance as well as to the database to read redo logs. The ASM login user ID must have SYSDBA authority, or SYSASM authority if you set the ASM_ASSYSASM parameter to Y in the READER statement in the PowerExchange Express CDC configuration file.
Answer:
Can you make your archived redo logs available for diagnostic use by Informatica Global Customer Support if an error or anomaly occurs during CDC processing?: Answer:
Do you need to capture changes from a RAC? How many member nodes does the RAC contain, including inactive nodes?: Answer:
What is the average amount of archive log that is created per hour during peak and non-peak periods for the Oracle database?: Answer:
What is the typical size of units of work (UOWs) for the source tables?: Answer:
Does the Oracle system have the capacity to run PowerExchange Express CDC for Oracle locally?: Answer:
Do you have unkeyed source tables for which you want to capture unique rowids?: Answer:
Do you need to capture changes for NUMBER columns that have a precision greater than 28 or an undefined length?: Answer:
Do you need to capture changes for FLOAT columns that have a precision greater than 15?: Answer:
Do you need to capture change data from an Oracle Data Guard logical or physical standby database?: Answer:
Do you need to capture change data from tablespaces that use Oracle Transparent Data Encyrption (TDE)? If yes, what is the TDE password?: Answer:
Do you need to capture change data from Oracle index-organized tables?: Answer:
Do you need to capture change data from a pluggable database (PDB) in an Oracle multitenant environment?: Answer:
Do you need to capture Oracle direct-path operations?: Answer:
Do you need to capture change data for a cloud-based database deployed in Amazon RDS for Oracle?: Answer: