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
- A Proof of Golden Section of Fibonacci SequenceGo
- [題解]P5858 Golden SwordGo
- OGG4DB2 for IBM i PURGEOLDEXTRACTS not workingDB2IBM
- ARC179D Portable Gate
- SonarQube 的 Quality Gate 是指什麼?
- pre/post gate sim 模擬筆記筆記
- 什麼是請求引數、表單引數、url引數、header引數、Cookie引數?一文講懂HeaderCookie
- python疑問5:位置引數,預設引數,可變引數,關鍵字引數,命名關鍵字引數區別Python
- 12.MyBatis學習--對映檔案_引數處理_單個引數&多個引數&命名引數MyBatis
- Java對比有引數和無引數Java
- 引數配置
- python引數Python
- 超引數
- mt引數
- COMPATIBLE引數
- 常用的jvm配置引數 :永久區引數配置JVM
- nginx 常見引數以及重定向引數配置Nginx
- 引數匹配模型——Python學習之引數(二)模型Python
- 引數的定義和引數的傳遞
- c# 方法引數(傳值,傳引用,ref,out,params,可選引數,命名引數)C#
- Bash變數和引數變數
- python變數和引數Python變數
- Nginx編譯引數大全 configure引數中文詳解Nginx編譯
- 函式引數 引數定義函式型別函式型別
- TypeScript 函式可選引數和預設引數TypeScript函式
- C技巧:結構體引數轉成不定引數結構體
- vue17自定義指令(有引數,無引數)Vue
- 引數匹配順序——Python學習之引數(三)Python
- postman 請求引數和 Spring Boot Controller 接受引數PostmanSpring BootController
- Python函式/動態引數/關鍵字引數Python函式
- 小程式內引數和掃碼引數統一
- livewire 中wire:click=test('中文引數')引數報錯
- 引數校驗
- SweepGradient的引數
- Python多值引數Python
- 引數彙總
- (2)python引數Python
- arp命令 引數