goldengate安裝配置手冊_v-資料下載頁

【導讀】3單機?4RAC?5RAC?

　　

【正文】 ${ggsci_mand} exit EOF` } case $1 in 39。start39。) start manager call_ggsci 39。start manager39。 there is a small delay between issuing the start manager mand and the process being spawned on the OS. wait before checking sleep ${start_delay_secs} check whether manager is running and exit accordingly check_process 。 39。stop39。) attempt a clean stop for all nonmanager processes call_ggsci 39。stop er *39。 ensure everything is stopped call_ggsci 39。stop er *!39。 call_ggsci 39。kill er *39。 stop manager without (y/n) confirmation call_ggsci 39。stop manager!39。 exit success exit 0 需求規格說明書 20 版權所有 2021 。 39。check39。) check_process 。 39。clean39。) attempt a clean stop for all nonmanager processes call_ggsci 39。stop er *39。 ensure everything is stopped call_ggsci 39。stop er *!39。 in case there are lingering processes call_ggsci 39。kill er *39。 stop manager without (y/n) confirmation call_ggsci 39。stop manager!39。 exit success exit 0 。 39。abort39。) ensure everything is stopped call_ggsci 39。stop er *!39。 in case there are lingering processes call_ggsci 39。kill er *39。 stop manager without (y/n) confirmation call_ggsci 39。stop manager!39。 exit success exit 0 。 esac 添加一個應用程序 profile [oracle@node1 ggate]$ cd $ORA_CRS_HOME/bin [oracle@node1 bin]$ pwd /u01/app/oracle/product/[oracle@node1 bin]$ crs_profile –create GG_app –t application \ –r ggvip –a /ggate/ –o ci=10 其中： r ggvip 表示 ggvip 必須在 GoldenGate 啟動之前運行， a /ggate/ 指定 action 腳本的位置， 在每個節點必須都可用 –o ci=10： 檢查的時間間隔設置為 10 把這個資源注冊到 CRS: 版權所有 2021 21 [oracle@node1 bin]$ crs_register GG_app 把 vip 的所有權給 root,在 root 用戶下執行： [root@node1 bin] ./crs_setperm ggvip –o oracle 為 oracle 用戶分配啟動這個資源的權限： [root@node1 bin] ./crs_setperm GG_app –u user:oracle:rx 通過 oracle 用戶啟動這個資源： [oracle@node1 bin]$ crs_start GG_app Attempting to start `GG_app` on member `node1` Start of `GG_app` on member `node1` succeeded. 查看資源狀態顯示如下： [oracle@node1 bin]$ crs_stat GG_app t Name Type Target State Host GG_app application ONLINE ONLINE node1 測試節點遷移 在測試環境中可以使用 crs_relocate –f GG_app 使它強行漂移 ： 過程顯示如下： [oracle@node1 ~]$ crs_stat t Name Type Target State Host GG_app application ONLINE ONLINE node1 ggvip application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node2 application ONLINE ONLINE node2 ora.... application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node2 application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node1 application ONLINE ONLINE node1 application ONLINE ONLINE node1 application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node2 application ONLINE ONLINE node2 application ONLINE ONLINE node2 application ONLINE ONLINE node2 [oracle@node1 ~]$ crs_relocate f GG_app Attempting to stop `GG_app` on member `node1` Stop of `GG_app` on member `node1` succeeded. Attempting to stop `ggvip` on member `node1` Stop of `ggvip` on member `node1` succeeded. Attempting to start `ggvip` on member `node2` Start of `ggvip` on member `node2` succeeded. 需求規格說明書 22 版權所有 2021 Attempting to start `GG_app` on member `node2` Start of `GG_app` on member `node2` succeeded. [oracle@node1 ~]$ crs_stat t Name Type Target State Host GG_app application ONLINE ONLINE node2 ggvip application ONLINE ONLINE node2 ora.... application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node2 application ONLINE ONLINE node2 ora.... application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node2 application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node1 application ONLINE ONLINE node1 application ONLINE ONLINE node1 application ONLINE ONLINE node1 ora.... application ONLINE ONLINE node2 application ONLINE ONLINE node2 application ONLINE ONLINE node2 application ONLINE ONLINE node2 可以看到 GoldenGate 成功轉移到 2 節點運行了。 6 常見錯誤 及解決方法 OGG00446 啟動源端抽取進程 extnd, 錯誤顯示如下： 20210817 11:11:38 ERROR OGG00446 Oracle GoldenGate Capture for Oracle, : Could not find archived log for sequence 45835 thread 1 under default destinations SQL SELECT name FROM v$archived_log WHERE sequence = :ora_seq_no AND thread = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 39。YES39。 AND deleted = 39。NO39。 AND name not like 39。+%39。 AND standby_dest = 39。NO39。 , error retrieving redo file name for sequence 45835, archived = 1, use_alternate = 0Not able to establish initial position for begin time 20210815 17: