修改ogg主库的tail日志文件大小

1.查看当前主库配置的trail情况

GGSCI (rac01) 23> info exttrail *

Extract Trail: ./dirdat/ep
Seqno Length: 9
Flip Seqno Length: no
Extract: DPEP
Seqno: 79
RBA: 8913919
File Size: 10M

Extract Trail: ./dirdat/ep
Seqno Length: 9
Flip Seqno Length: no
Extract: EXTEP
Seqno: 10
RBA: 48649101
File Size: 100M

2.停掉主库的相关进程
GGSCI (rac01) 26> stop dpep
GGSCI (rac01) 27> stop extep


3.修改pump进程
GGSCI (rac01) 29> alter rmttrail ./dirdat/ep, extract DPEP, megabytes 100
RMTTRAIL altered.

4.查看修改是否成功

GGSCI (rac01) 30> info exttrail *

Extract Trail: ./dirdat/ep
Seqno Length: 9
Flip Seqno Length: no
Extract: DPEP
Seqno: 79
RBA: 8913919
File Size: 100M

Extract Trail: ./dirdat/ep
Seqno Length: 9
Flip Seqno Length: no
Extract: EXTEP
Seqno: 10
RBA: 48649101
File Size: 100M

 

GGSCI (rac01) 31> INFO RMTTRAIL *

Extract Trail: ./dirdat/ep
Seqno Length: 9
Flip Seqno Length: no
Extract: DPEP
Seqno: 79
RBA: 8913919
File Size: 100M

Extract Trail: ./dirdat/ep
Seqno Length: 9
Flip Seqno Length: no
Extract: EXTEP
Seqno: 10
RBA: 48649101
File Size: 100M

5.重启动相应的进程
GGSCI (rac01) 26> start dpep
GGSCI (rac01) 27> start extep

语法:

原文地址:https://www.cnblogs.com/hxlasky/p/15064532.html