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

This article mainly explains the "SharePlex deletion why do not need the queue", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "SharePlex deletion why do not need the queue" bar!

No queues are required for SharePlex deletion

After version 9.x, queues can be deleted using the delete command in the sp_ctrl console. / * the following deletions apply to 8.x and 9.x versions / * take deleting post queues as an example. Export and import queues are consistent with this method.

Correct vardir path for 1.export SP_SYS_VARDIR=

2.sp_ctrl > shutdown / / the link must be stopped before the queue can be deleted

3. Confirm queue file

Cd $SP_SYS_VARDIR/rim [root@splextar rim] # ls-ltr / / confirm all queue files under rim so that you can confirm whether to delete files later after deleting the queue. Total 188oracle oinstall RW total-1 oracle oinstall 24 Sep 7 10:48 shstinfo.ipc-rw-rw-r-- 1 oracle oinstall 24 Sep 7 10:48 shmaddr.loc-rw-r--r-- 1 oracle oinstall 623 Sep 7 10:51 RS.c0a8cc6f.4-rw-r--r-- 1 oracle oinstall 8388609 Sep 7 10:51 cdc01+P+o.source-c.target+0.0000000-rw-r--r-- 1 oracle oinstall 8388609 Sep 7 10:51 te01+P+o.source- Oracle oinstall 8388609 Sep 7 10:54 cdc01+P+o.source-c.target+8.0000000-rw-r--r-- 1 oracle oinstall 8192 Sep 7 10:54 te01+P+o.source-o.target.sq-rw-r--r-- 1 oracle oinstall 8388609 Sep 7 10:54 te01+P+o.source-o.target+7.0000000-rw-r--r-- 1 oracle oinstall 5128 Sep 7 10:54 te01+P+o.source-o.target.q-rw-r- -oracle oinstall-1 oracle oinstall 8192 Sep 7 10:59 cdc01+P+o.source-c.target.sq-rw-r--r-- 1 oracle oinstall 5128 Sep 7 10:59 cdc01+P+o.source-c.target.q

4. Delete unwanted post queues

[oracle@splextar 866splex] $export SP_SYS_VARDIR=/SPLEX/ VARDIR [oracle @ splextar 866splex] $sp_ctrlsp_ctrl > shutdown # you need to close the link [oracle@splextar 866splex] $qview-iqview > qsetupqview > list / * to delete the queue. You can see that I have two post queues here. The queue names are cdc01 and te01. I want to delete the cdc01 queue The following queues exist: cdc01+P+o.source-c.target subqueues range from 0 to 8 WRITER + PI+11rac1+sp_mport+0xc0a8cc6f (192.168.204.111) READER + PP+cdc01+sp_opst_mt+o.source-c.target te01+P+o.source-o.target subqueues range from 0 to 7 WRITER + PI+11rac1+sp_mport+0xc0a8cc6f (192.168.204.111) READER + PP+te01+sp_opst_mt+o.source-o.target qview > deleteq cdc01+P+o.source-c.target qview > List / * you can see that the cdc queue has been deleted: The following queues exist: te01+P+o.source-o.target subqueues range from 0 to 7 WRITER + PI+11rac1+sp_mport+0xc0a8cc6f (192.168.204.111) READER + PP+te01+sp_opst_mt+o.source-o.target restart link: restart cop

5. Confirm that the corresponding files of the operating system have been deleted

Cd $SP_SYS_VARDIR/ rim [root @ splextar rim] # ls-ltrtotal 100 te01+P+o.source-o.target+0.0000000-rw-r--r-- 1 oracle oinstall 8388609 Sep 7 10:54 te01+P+o.source RS.c0a8cc6f.4-rw-r--r-- 1 oracle oinstall 8388609 Sep 7 10:51 te01+P+o.source-o.target+0.0000000-rw-r--r-- 1 oracle oinstall 8192 Sep 7 10:54 te01+P+o.source-o.target.sq-rw-r--r-- 1 oracle oinstall 8388609 Sep 7 10:54 te01+P+o.source -o.targetbrush 7.0000000 te01+P+o.source-o.target.q-rw-rw-r---1 oracle oinstall 5128 Sep 7 10:54 te01+P+o.source-o.target.q-rw-rw-r-- 1 oracle oinstall 24 Sep 7 11:06 shstinfo.ipc-rw-rw-r-- 1 oracle oinstall 24 Sep 7 11:06 shmaddr.loc

6. Start the link

Sp_cop-uport &

7. Confirm that other queues on the link replicate properly

Thank you for your reading, the above is the content of "Why SharePlex deletion does not need queue". After the study of this article, I believe you have a deeper understanding of why SharePlex deletion does not need queue, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.