golden gate 引數 PURGEOLDEXTRACTS
官方文件上的說明如下:
PURGEOLDEXTRACTS:Purges trail data that is no longer needed(按規則清除主端或者是備端的不再需要的跟蹤檔案)
Using PURGEOLDEXTRACTS as a Manager parameter is preferred over using the Extract or
Replicat version of PURGEOLDEXTRACTS . As a Manager parameter, PURGEOLDEXTRACTS allows
you to manage trail files in a centralized fashion and take into account multiple processes.
Use USECHECKPOINTS to purge when all processes are finished with a file as indicated by
checkpoints. This is the default, but it can be turned off with the NOUSECHECKPOINTS
option. Basing the purging on checkpoints ensures that no data is deleted until all
processes are finished with it. USECHECKPOINTS is checked whether or not the parameter
is explicitly defined with PURGEOLDEXTRACTS , unless there is an explicit
NOUSECHECKPOINTS entry. Basing purges on checkpoi nts is essential in a production
environment to ensure data integrity. USECHECKPOINTS considers the checkpoints of both
Extract and Replicat before purging.
Use the MINKEEP rules to set a minimum amount of time to keep unmodified data:
Use MINKEEPHOURS or MINKEEPDAYS to keep data for
Use MINKEEPFILES to keep at least
is 1 .
Use only one of the MINKEEP options. If more th an one is used, Oracle GoldenGate selects one of them based on the following:
If both MINKEEPHOURS and MINKEEPDAYS are specified, only the last one is accepted, and the other will be ignored.
If either MINKEEPHOURS or MINKEEPDAYS is used with MINKEEPFILES , then MINKEEPHOURS or MINKEEPDAYS is accepted, and MINKEEPFILES is ignored.
簡譯: 使用跟蹤檔案中的檢查點來判斷是否要被清除,但是在清除時還有遵循一定的 原則。用MINKEEP 來確定要保留的最小時間。主要作用來防止硬碟空間被無限的使用。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23062014/viewspace-742095/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- golden gate 引數說明Go
- Golden Gate 初探Go
- ORACLE golden gate 機制OracleGo
- 初探Oracle Golden Gate(一)OracleGo
- zt_oracle golden gateOracleGo
- 初次參與Golden -Gate POC,希望有機會做Golden -Gate for ERPGo
- Oracle Golden Gate 系列小結OracleGo
- Oracle golden gate程式說明OracleGo
- 配置Golden Gate 密碼加密Go密碼加密
- oracle golden gate 安裝配置OracleGo
- Golden Gate的definition檔案Go
- Oracle Golden Gate 安裝指南OracleGo
- Oracle Golden Gate 系列 小結OracleGo
- Golden Gate的一次教訓Go
- Oracle Golden Gate體系架構詳解OracleGo架構
- 一個奇怪的Golden Gate的問題Go
- golden gate同步的表結構修改檢查Go
- 一個Golden Gate實時資料分發的例子Go
- 《Oracle Golden Gate 概念和原理》-新手入門->深入解析-圖文-可下載OracleGo
- Oracle Golden Gate 有關Data Pump 重置 trail 序列號 測試 說明OracleGoAI
- 除錯PURGEOLDEXTRACTS除錯
- IBM實時資料複製和同步解決方案 and IBM CDC ORACLE GOLDEN GATE 比較IBMOracleGo
- Oracle Golden Gate 系列十二 -- GG 資料初始化裝載二 基於SCN 的初始化 說明 與 示例OracleGo
- kettle 引數——變數引數和常量引數變數
- 論在EBS,Siebel,PS,JDE等應用系統中部署Exadata,Golden-gate,Reri,DBV,AV,RAC,IDM 等的N個理由.Go
- Oracle引數-隱藏引數Oracle
- 什麼是請求引數、表單引數、url引數、header引數、Cookie引數?一文講懂HeaderCookie
- 使用PURGEOLDEXTRACTS設定goldengate自動清除trail fileGoAI
- ARC179D Portable Gate
- Swift語言中為外部引數設定預設值可變引數常量引數變數引數輸入輸出引數Swift變數
- c# 方法引數_值引數C#
- c# 方法引數_引用引數C#
- 動態引數,靜態引數
- C#中的值引數,引用引數及輸出引數C#
- Swift學習筆記(三十三)——常量引數,變數引數和inout引數Swift筆記變數
- python疑問5:位置引數,預設引數,可變引數,關鍵字引數,命名關鍵字引數區別Python
- JavaScript形式引數和實際引數JavaScript
- Oracle引數檔案解析——引數解析Oracle