Oracle 11g Release 2

All of the functionality that Replication Agent supports for Oracle Database 11g Release 1 is also supported by Replication Agent for Oracle Database 11g Release 2. Replication Agent also supports some functionality introduced by Oracle Database 11g Release 2.

Note: If you want to replicate tables compressed for online transaction processing (OLTP), apply first the Oracle patch# 129050503.

Replication Agent supports functionality common to both Oracle Database 11g Release 1 and Oracle Database 11g Release 2, including:

Oracle DDL and DML replication in systems with and without Automatic Storage Management (ASM) and Real Application Clusters (RAC).
Use of the Oracle Recovery Manager (RMAN) utility to truncate old archive log files.
Use of the Oracle Recycle Bin and replication of Oracle Flashback operations.
Oracle Data Guard.

Replication Agent also supports some features that are new as of Oracle Database 11g Release 2:

Use of the FORCE option with a CREATE OR REPLACE TYPE statement on types with type dependencies.
DDL statements on tables enabled for Flashback Data Archive.
Version 11.2 time zone files and new time zone behavior.

Network Configuration File Location and Structure
The tnsnames.ora file is located in ORACLE_HOME\network\admin. In an Oracle Database 11g Release 2 instance running ASM or RAC, the tnsnames.ora file is read by default from the grid infrastructure home directory at Grid_home\network\admin.
Time Zone File
By default, Oracle Database 11g Release 2 uses the large time zone file, timezone_11.dat. This file contains all the time zones defined in the database.
User-Defined Type Dependencies
You can use the CREATE OR REPLACE TYPE command to change the definition for an existing user-defined type. However, this command throws an error if the referenced type has table or type dependencies.
Flashback Data Archive Support for DDL Commands
Oracle Flashback allows database administrators and users to view past states of database objects and to restore database objects to a previous state without using point-in-time recovery. Users can query past data, query metadata to build a detailed history of changes, recover data to a previous point in time, and roll back transactions while the database is online.

Parent topic: Oracle-Specific Considerations