Use this procedure when you want to restore the databases to the Greenplum Database system master where you performed the backup.
Note
This restore runs in parallel on multiple servers.
The destination host must have a Greenplum version that is the same or higher than the source database.
The Commvault software uses the gpdbrestore command with the following options:
-
The name of the databases that the backup includes (-x)
-
The string that was set in the backup. The software sets the value to 'cv' (-prefix)
-
The do not prompt option (-a)
-
The number of parallel processes to use (-B)
-
The log file directory (-l)
-
The backup directory (-u)
For a complete description of the options, go to the Pivotal website, gpdbrestore.
Procedure
-
From the CommCell Browser, expand Client Computers > client.
-
Right-click the client, point to View and then click Backup History.
-
From the Backup History Filter view, select the Completed Offline Full job and click OK.
-
Right-click the job and then click Browse and Restore.
-
Optional: Use non-default Browse and Restore options. See Browse and Restore.
-
From the Browse window, select the databases to restore in the right pane and click Recover All Selected.
The Restore Options dialog box is displayed.
-
On the General tab, from the Destination Client list, select the master host.
-
The databases that the software will restore are listed in the Database list section and the instance is listed in the Source Instance field.
-
On the Job Initiation tab, specify whether to run the backup now or if it will be scheduled.
Note
If you selected Schedule, set up the schedule.
For information on configuring a restore schedule, see Schedule Restores.
-
Click OK to close the Restore Options dialog box and start the restore.