Shulou(Shulou.com)05/31 Report--

This article will explain in detail how OGG modifies the size of the trail file. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

Lab-Changing the size of trail files

First look at the original document:

Changing the size of trail files

Change the size of trail files

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.

You can change the size of the trail file by adjusting the MEGABYTES parameter with the alter command, using ALTER EXTTRAIL.

Or ALTER RMTTRAIL depends on whether the trail file is local or somewhere else

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.

Use the following command to get the location of the trail file you want to modify, and the group to which your trail file belongs

(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

-------------------------------------------------------

source end

Stop the extraction process

stop group_name

Stop the push process

stop group_name

Target:

Stop replication process

stop group_name

View information at source

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

Run command:

1. ALTER RMTTRAIL /u01/ogg/dirdat/kt, EXTRACT ggex, MEGABYTES 60--changed to 60M

2, ALTER EXTTRAIL /u01/ogg/dirdat/kt, EXTRACT ggpump, MEGABYTES 60---changed to 60M

3、SEND EXTRACT ggex, ROLLOVER

4、SEND EXTRACT ggpump, ROLLOVER

start the process

start

Check if there has been a change:

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

About "OGG how to modify the size of the trail file" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it to let more people see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.