How OGG modifies the size of trail files
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.
