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 檔案加密AI加密
- OGG刪除過期的trail檔案,shell實現AI
- OGG-extract程式對應的多餘trail檔案的刪除AI
- 修改上傳檔案大小
- 線上修改重做日誌檔案的大小
- 修改Oracle重做日誌檔案的大小Oracle
- 線上修改redo.log檔案的大小
- goldengate 捕捉oracle archive redo log 生成自有格式的trail檔案的大小記錄GoOracleHiveAI
- 修改PHP上傳檔案大小限制的方法PHP
- 增加日誌檔案,修改當前日誌檔案大小
- 【PHP】修改PHP配置檔案php.ini 上傳檔案的大小限制PHP
- 修改online redo日誌檔案大小
- kingsql 如何修改Oralce日誌檔案大小SQL
- MySQL 修改InnoDB重做日誌檔案的數量或大小MySql
- php.ini修改php上傳檔案大小限制PHP
- OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZEAI
- 如何設定redo log的OMF 及如何修改log檔案大小
- linux查詢某段時間修改的檔案的總大小Linux
- Postgres使用pg_resetwal命令修改wal日誌檔案大小的方法
- 日誌檔案的大小
- 得到檔案大小
- Trail檔案中的序列號不匹配造成的程式中斷AI
- git提交時支援檔名大小寫的修改Git
- windows下檔案系統支援的檔案大小Windows
- resize 資料檔案的大小
- 控制檔案大小的疑問
- 限制檔案大小及顯示檔案大小(正規表示式
- archive log檔案大小與redo log檔案大小關係探究Hive
- java 獲取資料夾大小、檔案大小、檔案個數Java
- goldengate trail檔案內容檢視工具logdumpGoAI
- linux+nginx+mysql+php系統修改檔案上傳大小限制LinuxNginxMySqlPHP
- 修改Oracle的配置檔案Oracle
- 生成固定大小的隨機檔案隨機
- 獲取上傳檔案的大小
- JavaScript限制上傳檔案的大小JavaScript
- 減小Delphi的Exe檔案大小
- ORACLE物理檔案大小的限制(轉)Oracle
- Oracle資料檔案大小的限制Oracle