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.