OGG強制刪除replicat
GGSCI (WINDOWS-0QO8SQ0) 6> dblogin userid system, password *****
Successfully logged into database.
GGSCI (WINDOWS-0QO8SQ0) 7> delete rep2
ERROR: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942: ta
ble or view does not exist (status = 942). Deleting from checkpoint table ggate.
checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL <DELETE FROM ggate.ch
eckpoint WHERE group_name = 'REP2' AND group_key = 2986303197>).
GGSCI (WINDOWS-0QO8SQ0) 8> delete rep2 force
ERROR: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942: ta
ble or view does not exist (status = 942). Deleting from checkpoint table ggate.
checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL <DELETE FROM ggate.ch
eckpoint WHERE group_name = 'REP2' AND group_key = 2986303197>).
GGSCI (WINDOWS-0QO8SQ0) 9> delete replicat rep2!
WARNING: Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942:
table or view does not exist (status = 942). Deleting from checkpoint table ggat
e.checkpoint, group 'REP2', key 2986303197 (0xb1ff5edd), SQL <DELETE FROM ggate.
checkpoint WHERE group_name = 'REP2' AND group_key = 2986303197>).
GGSCI (WINDOWS-0QO8SQ0) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
REPLICAT RUNNING REP1 00:00:00 00:00:01
直接刪除時,報錯
Could not delete DB checkpoint for REPLICAT REP2 (OCI Error ORA-00942.
因原OGG對應使用者ggate已經被刪除。
只好採用強制刪除
delete replicat rep2!
透過驚歎號來進行強制刪除
參考:http://ranjitnagi.blogspot.com/2013/01/gg-checkpoint-table-errorerror-could.html
http://chandu208.blogspot.com/2015/02/error-could-not-delete-db-checkpoint.html
<1h3 class="post-title entry-title" "="" style="font-weight: normal;padding: 0px;-webkit-tap-highlight-color: rgba(0, 0, 0, 0);position: relative;font-stretch: normal;font-size: 28px;line-height: normal">ERROR: Could not delete DB checkpoint for REPLICATDB version:
11.2.0.2.0OGG version:
11.2.1.0.3OS Version:
RHEL 6GGSCI (oracledev10) 10>
delete Replicat REP
ERROR: Could not delete DB checkpoint for REPLICAT REP (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ggs_admin.ggchkpt, group 'REP', key 2292316344 (0x88a1f8b8), SQL <DELETE FROM ggs_admin.ggchkpt WHERE group_name = 'REP' AND group_key = 2292316344>).
The above error was due to REPLICAT process added without specifying NODBCHECKPOINT argument when it got created initially.
Solution: Try deleting with "!" optionGGSCI (oracledev10) 12>
delete replicat REP !
WARNING: Could not delete DB checkpoint for REPLICAT REP (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ggs_admin.ggchkpt, group 'REP', key 2292316344 (0x88a1f8b8), SQL <DELETE FROM ggs_admin.ggchkpt WHERE group_name = 'REP' AND group_key = 2292316344>).Replicat REP Deleted now
Here, The “!” tells GoldenGate to ignore the checkpoint tableIf we wish to create Replicat
without checkpoint then use below command to create
ADD REPLICAT <group>, EXTTRAIL <trail>, NODBCHECKPOINTIf we want to create Replicat
WITH checkpoint then use below command to create
ADD CHECKPOINTTABLE ggs_admin.ggchkpt (
create if not exists)
ADD REPLICAT <group>, EXTTRAIL <trail>, CHECKPOINTTABLE ggs_admin.ggchkpt
Refer:
How Can I Delete A REPLICAT Created Without A Checkpoint Table? (Doc ID 965689.1)
連結:http://blog.itpub.net/8520577/viewspace-2119349/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31547066/viewspace-2655771/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- linux的刪除檔案命令和強制刪除命令Linux
- Ubuntu 強制刪除資料夾(非空)Ubuntu
- rimraf 命令強制刪除依賴庫檔案
- win10怎樣強制刪除dll檔案 win10系統強制刪除dll檔案的步驟Win10
- win10強制刪除資料夾的解決方法Win10
- win10強制刪除dll檔案的解決方法Win10
- OGG刪除過期的trail檔案,shell實現AI
- win10 eng刪不掉怎麼解決_win10如何強制刪除engWin10
- win10電腦怎麼刪除隱藏的流氓軟體 win10強制刪除流氓軟體Win10
- 阿里巴巴為什麼這樣強制從List中刪除元素阿里
- OGG的replicat程式的Time Since Chkpt一直增加,程式處於假死狀態
- win10系統強制刪除遠端桌面連線軟體的方法Win10
- win10系統下怎麼強制刪除不使用的語言包Win10
- ZBlog強制開啟 Debug 除錯模式除錯模式
- list增強for迴圈刪除元素報錯
- win10怎麼解除安裝軟體 強制刪除流氓軟體的辦法Win10
- 增強for為什麼不能刪除集合裡的元素
- 【Java】增強for迴圈,三種迭代的能否刪除Java
- php(js)批量刪除/單個刪除PHPJS
- 工作293:調節刪除順序刪除
- win10瀏覽器主頁被篡改怎麼改回來 如何刪除360導航強制主頁Win10瀏覽器
- mysql刪除主鍵索引,刪除索引語法MySql索引
- XShell、XFtp免費許可證增強:刪除標籤限制!FTP
- Oracle OGG 到 Kafka OGG-01431 OGG-01003 OGG-01151 OGG-01296 OGG-01668OracleKafka
- Redis 中的過期刪除策略和記憶體淘汰機制Redis記憶體
- iOS 多選刪除(附tableViewTips及單選刪除)iOSView
- 刪除資料
- 刪除歸檔
- Gitlab刪除分支Gitlab
- armbian刪除dockerDocker
- 級聯刪除
- jQuery刪除元素jQuery
- jQuery 刪除元素jQuery
- Elasticsearch 刪除文件Elasticsearch
- JavaScript 刪除cookieJavaScriptCookie
- 修改刪除表
- 不能刪除DBLINK
- MongoDB 刪除文件MongoDB