How to carry out shareplex daily maintenance documents
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.
