# Performing GaussDB (DWS) Restore

You can perform the restore of the GaussDB (DWS).

## Procedure

You can perform in place restore of a GaussDB (DWS).

1. 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]"

2. Use the following command to start the cluster after restore:

       python3 $[$GPHOME/script/GaussRoach.py] -t $[start]

3. 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.

×

Loading...