ITPub博客

首页 > 数据库 > Oracle > OGG 修改trail 文件的大小

OGG 修改trail 文件的大小

原创 Oracle 作者:huzhichengforce 时间:2014-06-12 17:36:28 0 删除 编辑
实验-修改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博客 ” ,链接:https://blog.itpub.net/26764973/viewspace-1181591/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-08-19

  • 博文量
    202
  • 访问量
    518268