SharePlex tips
–setup shareplex steps
1. install shareplex software at source and target
2. startup shareplex at source and target
3. stop post at target
4. activate config config_file at source
5. select current_scn from v$database; from source
6. expdp data from source using FLASHBACK_SCN
7. impdp data to target
8. reconcile queue q_tmp for o.SSID-o.TSID scn on target
9. start post at target
–reconcile steps
1.split the table to an individule queue q_tmp
2.stop post queue q_tmp
3.exp, expdp on source with flashback_scn xxx
4.truncate table on target and imp, impdp it
5.reconcile queue q_tmp for o.LPSIE-o.LPSIE scn on target
5.start post queue q_tmp
–compare and repair commands
|
1
2
3
|
compare table siebel.S_SRM_TASK_HIST to siebel.S_SRM_TASK_HIST target alexzeng.wordpress.com@o.SIEBEL repair
show compare
cancel compare
|
–copy command
|
1
2
3
4
5
6
7
8
|
On target:
start launcher
stop post
On source:
copy siebel.S_SRM_DATA to siebel.S_SRM_DATA;
copy status;
On target:
stop launcher
|
–check the current shareplex Oracle user
|
1
|
list param read
|
–activate configure file got lock error, try set this
|
1
|
setenv SP_OCF_SKIP_ANALYZE 1
|
–skip post object ids
|
1
2
3
|
set param SP_OPO_DISABLE_OBJECT_NUM 90039,90516,88963,90035,90040
reset param SP_OPO_DISABLE_OBJECT_NUM
set param SP_QUE_MAX_QUEUES 50
|
–delete queue
|
1
2
3
4
5
6
|
qview -i
qsetup
list
deleteq xq_row_id_partM+P+o.LPSIE-o.LPSIE
–delete queue user, find the right line by nslookup IP
deluser lpsie+X +PX+lpsie+sp_xport+0x0a1145af
|