Greenplum failed segment恢复方法

1、启动数据服务

[[email protected] ~]$ gpstart
           

2、生成恢复配置文件

[[email protected] ~]$ gprecoverseg -o ./recov
[[email protected] ~]$ cat recov 
filespaceOrder=
sdw2:50000:/home/data/gpdata/mirror/gpseg0
sdw2:50001:/home/data/gpdata/mirror/gpseg1
sdw2:40000:/home/data/gpdata/primary/gpseg2
sdw2:40001:/home/data/gpdata/primary/gpseg3
           

3、使用配置文件恢复节点

[[email protected] ~]$ gprecoverseg -i ./recov 
...
20190618:17:26:41:003078 gprecoverseg:mdw:gpadmin-[INFO]:-******************************************************************
20190618:17:26:41:003078 gprecoverseg:mdw:gpadmin-[INFO]:-Updating segments for resynchronization is completed.
20190618:17:26:41:003078 gprecoverseg:mdw:gpadmin-[INFO]:-For segments updated successfully, resynchronization will continue in the background.
20190618:17:26:41:003078 gprecoverseg:mdw:gpadmin-[INFO]:-
20190618:17:26:41:003078 gprecoverseg:mdw:gpadmin-[INFO]:-Use  gpstate -s  to check the resynchronization progress.
20190618:17:26:41:003078 gprecoverseg:mdw:gpadmin-[INFO]:-******************************************************************
           

4、查看节点状态

[[email protected] ~]$ gpstate -s