OGG 修改trail 檔案的大小
實驗-修改trail檔案的大小
先看原文件:
Changing the size of trail files
更改trail 檔案的大小
You can change the size of trail files with the MEGABYTES option of either the ALTER EXTTRAIL
or ALTER RMTTRAIL command, depending on whether the trail is local or remote. To change
the file size, follow this procedure.
你可以透過alter 命令調整MEGABYTES 引數的值來改變trail 檔案的大小,是使用ALTER EXTTRAIL
或者 ALTER RMTTRAIL要看trail 檔案是在本地還是在其它地方
1. Issue one of the following commands, depending on the location of the trail,to view the
path name of the trail you want to alter and the name of the associated Extract group.
Use a wildcard to view all trails.
使用下面的命令獲得你想修改trail 檔案的存放地址,你的trail檔案所屬的組
(Remote trail)
INFO RMTTRAIL *
(Local trail)
INFO EXTTRAIL *
2. Issue one of the following commands, depending on the locationof the trail, to change
the file size.
(Remote trail)
ALTER RMTTRAIL, EXTRACT , MEGABYTES
(Local trail)
ALTER EXTTRAIL, EXTRACT , MEGABYTES
3. Issue the following command tocause Extract to switch to the next file in the trail.
SEND EXTRACT, ROLLOVER
-------------------------------------------------------------------------分割線---------------------------------------------------------------------------------------------------------------
源端
停止抽取程式
stop group_name
停止推送程式
stop group_name
目標端:
停止複製程式
stop group_name
在源端檢視資訊
GGSCI (OGG1) 64> info exttrail *
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGEX
Seqno: 14
RBA: 3822
File Size: 5M
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGPUMP
Seqno: 13
RBA: 3956
File Size: 5M
執行命令:
1、ALTER RMTTRAIL /u01/ogg/dirdat/kt, EXTRACT ggex, MEGABYTES 60--改成60M
2、ALTER EXTTRAIL /u01/ogg/dirdat/kt, EXTRACT ggpump, MEGABYTES 60---改成60M
3、SEND EXTRACT ggex, ROLLOVER
4、SEND EXTRACT ggpump, ROLLOVER
啟動程式
start
檢視是否發生改變:
GGSCI (OGG1) 91> info exttrail *
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGEX
Seqno: 17
RBA: 1007
File Size: 60M
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGPUMP
Seqno: 16
RBA: 1149
File Size: 60M
先看原文件:
Changing the size of trail files
更改trail 檔案的大小
You can change the size of trail files with the MEGABYTES option of either the ALTER EXTTRAIL
or ALTER RMTTRAIL command, depending on whether the trail is local or remote. To change
the file size, follow this procedure.
你可以透過alter 命令調整MEGABYTES 引數的值來改變trail 檔案的大小,是使用ALTER EXTTRAIL
或者 ALTER RMTTRAIL要看trail 檔案是在本地還是在其它地方
1. Issue one of the following commands, depending on the location of the trail,to view the
path name of the trail you want to alter and the name of the associated Extract group.
Use a wildcard to view all trails.
使用下面的命令獲得你想修改trail 檔案的存放地址,你的trail檔案所屬的組
(Remote trail)
INFO RMTTRAIL *
(Local trail)
INFO EXTTRAIL *
2. Issue one of the following commands, depending on the locationof the trail, to change
the file size.
(Remote trail)
ALTER RMTTRAIL
(Local trail)
ALTER EXTTRAIL
3. Issue the following command tocause Extract to switch to the next file in the trail.
SEND EXTRACT
-------------------------------------------------------------------------分割線---------------------------------------------------------------------------------------------------------------
源端
停止抽取程式
stop group_name
停止推送程式
stop group_name
目標端:
停止複製程式
stop group_name
在源端檢視資訊
GGSCI (OGG1) 64> info exttrail *
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGEX
Seqno: 14
RBA: 3822
File Size: 5M
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGPUMP
Seqno: 13
RBA: 3956
File Size: 5M
執行命令:
1、ALTER RMTTRAIL /u01/ogg/dirdat/kt, EXTRACT ggex, MEGABYTES 60--改成60M
2、ALTER EXTTRAIL /u01/ogg/dirdat/kt, EXTRACT ggpump, MEGABYTES 60---改成60M
3、SEND EXTRACT ggex, ROLLOVER
4、SEND EXTRACT ggpump, ROLLOVER
啟動程式
start
檢視是否發生改變:
GGSCI (OGG1) 91> info exttrail *
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGEX
Seqno: 17
RBA: 1007
File Size: 60M
Extract Trail: /u01/ogg/dirdat/kt
Extract: GGPUMP
Seqno: 16
RBA: 1149
File Size: 60M
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-1181591/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- OGG刪除過期的trail檔案,shell實現AI
- 處理OGG-02198 Incompatible record (logical EOF) in trail fileAI
- MySQL 修改InnoDB重做日誌檔案的數量或大小MySql
- linux查詢某段時間修改的檔案的總大小Linux
- 修改SharePoint上傳檔案大小限制(Changing Maximum Upload Size)
- Postgres使用pg_resetwal命令修改wal日誌檔案大小的方法
- git提交時支援檔名大小寫的修改Git
- 限制檔案大小及顯示檔案大小(正規表示式
- 生成固定大小的隨機檔案隨機
- JavaScript限制上傳檔案的大小JavaScript
- sed 修改檔案
- python 將檔案大小轉換為human readable 的大小表示Python
- linux 中根據檔案的大小進行檔案的查詢Linux
- ORACLE OGG引數修改引起佇列檔案異常導致抽取程式無法啟動Oracle佇列
- 限制 Apache日誌檔案大小的方法Apache
- Oracle歸檔檔案丟失導致OGG不用啟動Oracle
- 修改hosts檔案的小程式
- git修改檔案的名稱Git
- python 修改jenkins的配置檔案PythonJenkins
- 快速找到最近修改的檔案!
- SVN培訓筆記(下拉專案、同步修改、新增檔案、修改檔案、刪除檔案、改名檔案等)筆記
- Mac電腦hosts檔案如何修改?macOS修改Hosts檔案教程Mac
- Camstar MDB setfieldex 修改建模欄位不記錄Audit TrailAI
- apache上傳檔案大小限制Apache
- PbootCMS上傳檔案大小限制boot
- php檔案上傳大小限制PHP
- linux 修改hosts檔案以及修改hostnameLinux
- Git修改配置檔案Git
- windows 修改hosts檔案Windows
- python 修改文字檔案Python
- Linux檢視檔案大小的幾種方法Linux
- PG獲取檔案大小的幾種方式
- 使用vim修改linux中的檔案Linux
- 修改檔案的md5碼
- Java 例項 - 修改檔案最後的修改日期Java
- git提示檔案有修改但實際檔案無修改解決方案Git
- win10 如何修改hosts檔案 win10 如何修改host檔案Win10
- base64檔案大小計算
- linux 常用檢視埠,檔案大小Linux