【導(dǎo)讀】3單機(jī)?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 需求規(guī)格說明書 20 版權(quán)所有 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 添加一個應(yīng)用程序 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 啟動之前運(yùn)行， a /ggate/ 指定 action 腳本的位置， 在每個節(jié)點(diǎn)必須都可用 –o ci=10： 檢查的時間間隔設(shè)置為 10 把這個資源注冊到 CRS: 版權(quán)所有 2021 21 [oracle@node1 bin]$ crs_register GG_app 把 vip 的所有權(quán)給 root,在 root 用戶下執(zhí)行： [root@node1 bin] ./crs_setperm ggvip –o oracle 為 oracle 用戶分配啟動這個資源的權(quán)限： [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. 查看資源狀態(tài)顯示如下： [oracle@node1 bin]$ crs_stat GG_app t Name Type Target State Host GG_app application ONLINE ONLINE node1 測試節(jié)點(diǎn)遷移 在測試環(huán)境中可以使用 crs_relocate –f GG_app 使它強(qiáng)行漂移 ： 過程顯示如下： [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. 需求規(guī)格說明書 22 版權(quán)所有 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 成功轉(zhuǎn)移到 2 節(jié)點(diǎn)運(yùn)行了。 6 常見錯誤 及解決方法 OGG00446 啟動源端抽取進(jìn)程 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: