You can perform the restore of the GaussDB (DWS).
Procedure
You can perform in place restore of a GaussDB (DWS).
-
For Commvault, you need to add the following additional options for Roach tool:
-
For restore:
python3 $GPHOME/script/GaussRoach.py -t restore --clean --master-port master port number --media-type NBU --media-destination " CVOBConfigSetting=sCVXBSAConfig_Instance name_Database name,CvInstanceName=Instance001 " --metadata-destination metadata destination path --backup-key backup key --nbu-on-remote --nbu-media-list /srv/BigData/mppdb/medialist --client-port 5000 --parallel-process 1 -
For metadata restore:
python3 $GPHOME/script/GaussRoach.py -t restore --media-type NBU --media-destination "CVOBConfigSetting=sCVXBSAConfig_Instance name_Database name,CvInstanceName=Instance001" -
To restore from a specific backup copy, specify CvRestoreCopyPrec parameter with required copy precedence number.
-
For Restore:
python3 $GPHOME/script/GaussRoach.py -t restore --clean --master-port master port number --media-type NBU --media-destination " CVOBConfigSetting=sCVXBSAConfig_Instance name_Database name,CvInstanceName=Instance001, CvRestoreCopyPrec=1" --metadata-destination metadata destination path --backup-key backup key --nbu-on-remote --nbu-media-list /srv/BigData/mppdb/medialist --client-port 5000 --parallel-process 1 -
For Metadata Restore:
python3 $GPHOME/script/GaussRoach.py -t restore --mediaType NBU --remoteMetaData "CVOBConfigSetting=sCVXBSAConfig_Instance name_Database name,CvInstanceName=Instance001,CvRestoreCopyPrec=1"
-
-
-
Use the following command to start the cluster after restore:
python3 $GPHOME/script/GaussRoach.py -t start -
Use the following command to check the cluster status:
gs_om -t status
For more information about Roach tool specific options, you can refer to Huawei GaussDB (DWS) documentation.