High Level Steps of Migrating SAP System using Oracle Golden Gate

[Former Member]

Oracle Golden Gate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise1. Its modular architecture gives you the flexibility to extract and replicate selected data records, transnational changes, and changes to DDL (data definition language 2) across a variety of typologies. With this flexibility, and the filtering, transformation, and custom processing features of Oracle Golden Gate, you can support numerous business requirements:

Oracle Golden Gate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms across the enterprise1. Its modular architecture gives you the flexibility to extract and replicate selected data records, transnational changes, and changes to DDL (data definition language 2) across a variety of typologies. With this flexibility, and the filtering, transformation, and custom processing features of Oracle Golden Gate, you can support numerous business requirements:

• Business continuance and high availability.
• Initial load and database migration.
• Data integration.
• Decision support and data warehousing.Business continuance and high availability.
• Initial load and database migration.
• Data integration.
• Decision support and data warehousing

1) Identify schemas to be migrated.

2) Identify Triggers which needs to be disabled on 11g target database

3) Identify Sequences which needs to be replicated.

4) Identify Services which needs to be created on the 11g target database

5) Identify cron jobs or any other jobs which needs to be transferred to 11g target database server.

6) Verify Firewall is open between the 11g source and 11g target database and also the clients connecting to the 11g target database.

7) Check the GG ports are enabled for source and target (7809-7840)

😎 Create database on 11g target cluster

9) Install OGG on source and target servers.

10) Enable the supplementary login for database and table level GG configuration on source

11) Setup the GG environment on source and target.

12) Configure the GG parameter files on source and target.

13) Start OGG Manager &  Extract on source database.

14) Perform consistent Export on source database with current SCN for initial load.

15) Perform initial load using import on the target database

16) Start OGG replication on the target database after SCN(which is used in EXPDP)

17) Keep target database in-sync with source database.

18) Lock all the user accounts on target database.

19) Perform test on target database.

20) Start SAP application.