Restoring the Greenplum Database to the Same System

You can restore the Greenplum databases to the same hosts that the software used for the backups.

Use this procedure when you want to restore the databases to the Greenplum Database system master where you performed the backup.

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.

Before You Begin

1. Perform a Greenplum backup.

2. Plan the configuration for the restore operations. After selecting the data that you want to restore, you will need to set the Advanced Restore Options for the restore operation.

   • General

   • Startup

   • Pre/Post

   • Copy Precedence

   • Data Path

   • Paths/Filters

   • Encryption

   • Map

Procedure

1. From the CommCell Browser, expand Client Computers > client > Greenplum > instance.

2. Right-click the subclient, point to All Tasks and then click Browse and Restore.

3. On the Browse and Restore dialog box, select Latest Backup and click View Content.

4. Optional: Use non-default Browse and Restore options. See Browse and Restore.

5. From the Browse window, select the database to restore in the right pane and click Recover All Selected.

   The Restore Options dialog box is displayed.

6. On the General tab, from the Destination Client list, select the master host.

7. 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 more information, see Schedule Restores.

8. Click OK to close the Restore Options dialog box and start the restore.