Goldengate Directory Repository迁移

一.背景:

客户工程师提出要求，希望将位于测试环境数据库的director repository迁移到比较稳定的生产环境。希望我们提供相关方案并进行迁移。

二.迁移方案

2.1.迁移数据库后修改WLS配置

1).停掉director server

2).expdp迁移director repository数据;

3).重启director server并修改数据源的属性(指向新的数据库)

2.2.官方资料说明

可以参照MOS上的文章:Moving the Director v2.0+ database repository to another host (文档 ID 1192548.1)

文章中提到的核心步骤如下:

1. Shutdown Director server 
2. Do an export of the existing Director schema repository 
3. Import the Director repository to the new database 
4. Restart Director server. It will be accessing the old repository at this time. 
5. Access the Weblogic console and access the datasource to view the properties: 
a. Open a web browser to: 
http://<Director server host>:7001/console 
b. Logon as weblogic/<password> default password is weblogic 
c. Under the Domain Structure tree, click on Services >> JDBC 
d. Under Section, click on Data Sources and click on the ggds-datasource 
e. Then click the Connection Pool tab to display the properties for this datasource 
f. Here, under Properties, you can update the database repository SID, TNS port and servername. 
g. Once the change is made, click Save and exit the console. 
3. The stop and restart Director server to be sure it can access the moved repository