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

How to split replicate, in view of this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

The extraction process of GG can extract about 30-50G of logs per hour, while the Replicat process can only deliver about one hour of logs per hour.

At the peak of business, the database generates a large number of logs. A large amount of accumulation will be generated at the disaster recovery end, and the replicat will be delayed, so it needs to be split to increase the speed of storage.

Each Replicat split consumes memory and CPU resources.

1, stop the replicat process

Stop rep_1

2. Check the SEQNO and RBA numbers of the split process.

Info rep_1

3. Edit the parameter file of the new process

Edit param rep_2

4, add a process group and add a tail file to it

Add replicat rep_2,exttrail. / dirdat/lt checkpointtable oggg.ckpt

5. Modify the pointer of the new queue to be the same as the previous queue

Alter rep_2, extseqno xx extrba 11111

6. Exclude tables in rep_1 that are split into rep_2

7, start the rep process

The answer to the question on how to split replicate is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.