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;
/