以下均在备节点上操作
1、停止HDB
su - hdpadm
HDB stop
2、kill调所有HDB相关进程
hdpadm@Ahanaprd01:/usr/sap/HDP/HDB00> HDB info
USER PID PPID %CPU VSZ RSS COMMAND
hdpadm 90119 90118 0.0 13400 6076 -sh
hdpadm 92809 90119 0.0 11496 3988 \_ /bin/sh /usr/sap/HDP/HDB00/HDB info
hdpadm 92842 92809 0.0 27052 3916 \_ ps fx -U hdpadm -o user:8,pid:8,ppid:8,pcpu:5,vsz:10,rss:10,args
hdpadm 294428 291980 0.4 85276836 1288800 \_ hdbdiserver -port 30076
hdpadm 294433 291980 0.7 89794796 1470348 \_ hdbwebdispatcher
hdpadm 291633 1 0.0 510160 39980 /usr/sap/HDP/HDB00/exe/sapstartsrv pf=/usr/sap/HDP/SYS/profile/HDP_HDB00_ahanaprd01
kill -9 294428
kill -9 294433
kill -9 291633
3、取消SR注册
hdbnsutil -sr_unregister --name=Ahanaprd01
4、重新注册,并开启强制全量同步
hdbnsutil -sr_register --remoteHost=Ahanaprd02 --force_full_replica --remoteInstance=00 --replicationMode=sync --name=Ahanaprd01 --operationMode=logreplay
5、启动HDB
HDB start
6、检查同步状态 --此步骤在主库操作
Ahanaprd02:~ # su - hdpadm
hdpadm@Ahanaprd02:/usr/sap/HDP/HDB00> cdpy
hdpadm@Ahanaprd02:/usr/sap/HDP/HDB00/exe/python_support> python systemReplicationStatus.py
|Database |Host |Port |Service Name |Volume ID |Site ID |Site Name |Secondary |Secondary |Secondary |Secondary |Secondary |Replication |Replication |Replication |Secondary |
| | | | | | | |Host |Port |Site ID |Site Name |Active Status |Mode |Status |Status Details |Fully Synced |
|-------- |---------- |----- |------------ |--------- |------- |---------- |---------- |--------- |--------- |---------- |------------- |----------- |----------- |-------------- |------------ |
|SYSTEMDB |ahanaprd02 |30001 |nameserver | 1 | 2 |Ahanaprd02 |ahanaprd01 | 30001 | 1 |Ahanaprd01 |YES |SYNC |ACTIVE | | True |
|HDP |ahanaprd02 |30007 |xsengine | 2 | 2 |Ahanaprd02 |ahanaprd01 | 30007 | 1 |Ahanaprd01 |YES |SYNC |ACTIVE | | True |
|S4P |ahanaprd02 |30040 |indexserver | 2 | 2 |Ahanaprd02 |ahanaprd01 | 30040 | 1 |Ahanaprd01 |YES |SYNC |ACTIVE | | True |
status system replication site "1": ACTIVE
overall system replication status: ACTIVE
Local System Replication State
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
mode: PRIMARY
site id: 2
site name: Ahanaprd02
567

被折叠的 条评论
为什么被折叠?



