本文详细介绍了使用 Oracle GoldenGate 进行数据库迁移的过程，包括禁用、删除、设置和启用 DDL 脚本，创建角色并授权给所有 Oracle GoldenGate 用户，确保平稳的数据迁移。
1. Run GGSCI.
2. STOP EXTRACT <group&get;
3. STOP REPLICAT <group&get;
4. Run SQL*Plus and log in as a user that has SYSDBA privileges.
5. Run the ddl_disable script.
6. Run the ddl_remove script,
7. Run the marker_remove script.
8. Run the marker_setup script.
9. Run the ddl_setup script.
10. Run the role_setup script.
11. Grant the role to all Oracle GoldenGate users
12. Run the ddl_enable.sql script.
2. STOP EXTRACT <group&get;
3. STOP REPLICAT <group&get;
4. Run SQL*Plus and log in as a user that has SYSDBA privileges.
5. Run the ddl_disable script.
6. Run the ddl_remove script,
7. Run the marker_remove script.
8. Run the marker_setup script.
9. Run the ddl_setup script.
10. Run the role_setup script.
11. Grant the role to all Oracle GoldenGate users
12. Run the ddl_enable.sql script.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
