Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about how to carry out shareplex daily maintenance documents, many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

2021-10-25

# # routine maintenance of SharePlex

Source (SRC):

192.168.1.101 db01

Target (TGT):

192.168.1.102 db02

SRC:

Su-oracle

Sp_ctrl

Show

Qstatus

Show capture detail

Show read detail

Show log reverse

Show config-View the currently used parameter file

List config-list all parameter files (used and unused)

View config config_name-View the specific contents of the parameter file

Log:

Oracle@wlccoddb1 log] $pwd

/ shareplex/vardir2200/log

[oracle@wlc log] $ls-l event_log

-rw-rw-rw- 1 oracle dba 784492 Jul 29 12:04 event_log

Turn off and start (source and destination):

-- shutdown

Sp_ctrl

Sp_ctrl > shutdown (shutdown force)

Ps-ef | grep sp_

-- start

Sp_cop &

Ps-ef | grep sp_

TGT:

Su-oracle

Sp_ctrl

Show-View the status of the process

Qstatus-View queue status

Show post detail-View queue details

Show post queue Q01 | Q02.... Detail-View specific queue details

Show log reverse-View logs

Log:

/ oradata2/shareplex/vardir2200/log

[oracle@wljh2 log] $ls-l event_log

-rw-rw-r-- 1 oracle dba 2007535 Jul 29 12:09 event_log

=

Note: in the directory below the repository, individual files will increase greatly. If it is too large (20000m), it is recommended to clean it up, back up before cleaning, and delete it after a period of time.

/ oradata2/shareplex/vardir2200/log

Backup command: cp filename.log filename.log_20170725

Cleanup command: > filename.log

After reading the above, do you have any further understanding of how to carry out shareplex daily maintenance documentation? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.