Oracle高级复制实施手记 2004-10-09

准备实施双向复制,今天在测试机器上测试了一把.

主体定义站点

hp-ux 11i

oracle 9.0.1.0.0(给这个版本折腾得很痛苦)

主体复制站点

windows 2000 server

oracle 9.0.1

1.

一般来说,global_name=db_name+domain_name

可以用alter database rename global_name to 来改变.对高级复制没有影响.

2.

-- You should wait until the DBA_REPCATLOG view is empty before resuming master activity.

-- 确认DBA_REPCATLOG 变空前才启动复制活动
SELECT COUNT(*) FROM DBA_REPCATLOG WHERE lower(GNAME) = 'web_repg';

-- Resume replication.

BEGIN
   DBMS_REPCAT.RESUME_MASTER_ACTIVITY (
      gname => 'web_repg');
END;
/