OGG 修改trail 檔案的大小

huzhichengforce發表於2014-06-12
實驗-修改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



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-1181591/,如需轉載,請註明出處,否則將追究法律責任。

相關文章