Specifying Additional Restore Options for PostgreSQL

Several additional options are available to further refine your restore operations. The following table describes these options, as well as the steps to implement them.

Be sure to read the overview material referenced for each feature prior to using them.

Option

Description

Related Topic

Startup Options

The Startup Options are used by the Job Manager to set priority for resource allocation. This is useful to give higher priority to certain jobs. You can set the priority as follows:

  1. From the CommCell Browser, navigate to <Client> | PostgreSQL | <Instance>.

  2. Right-click the FSBasedBackupSet, and then click All Tasks | Browse and Restore.

  3. In the Browse and Restore Options dialog box, click View Content.

  4. From the Browse window, select FSBasedBackupSet and click Recover All Selected.

  5. In the PostgreSQL Database Restore Options dialog box, click Advanced.

  6. In the Advanced Restore Options dialog box, select the Startup tab.

  7. Select Change Priority.

  8. Enter a priority number where 0 is the highest priority and 999 is the lowest priority.

  9. Select the Start up in suspended State to start the job in a suspended state.

  10. Click OK.

Refer to Job Priority and Priority Precedence.

Copy Precedence

By default, the system retrieves data from the storage policy copy with the lowest copy precedence. If the data was pruned from the primary copy, the system automatically retrieves data from the other copies of the storage policy in the lowest copy precedence to highest copy precedence order. Once the data is found, it is retrieved, and no further copies are checked.

You can retrieve data from a specific storage policy copy (Synchronous Copy or Selective Copy). If data does not exist in the specified copy, the data retrieve operation fails even if the data exists in another copy of the same storage policy. Follow the steps given below to retrieve the data from a specific storage policy copy:

  1. From the CommCell Browser, navigate to <Client> | PostgreSQL | <Instance>.

  2. Right-click the FSBasedBackupSet, and then click All Tasks | Browse and Restore.

  3. In the Browse and Restore Options dialog box, click View Content.

  4. From the Browse window, select FSBasedBackupSet and click Recover All Selected.

  5. In the PostgreSQL Database Restore Options dialog box, click Advanced.

  6. In the Advanced Restore Options dialog box, click Copy Precedence.

  7. On the Copy Precedence tab, select the Restore from copy precedence check box.

  8. Enter the copy precedence number.

  9. Click OK.

Refer to Recovering Data From Copies.

Data Path Options

Data Recovery operations use a specific data path (Library, MediaAgent, Drive Pool, and Drive) to perform the restore operations as configured in the CommCell. By default, the system automatically identifies the data path for the restore operations. You can change the data path at the restore level by selecting a specific MediaAgent, library, drive pool or drive in the Advanced Restore Options dialog.

The following are some of the important situations where you may need to change the data path:

  • To free heavily loaded resources such as MediaAgents and libraries.

  • A library suffers severe hardware damage and you need to move its media to a different library in order to access data secured by data protection operations.

  • A drive pool within a library is being used much more frequently than another, and a storage policy copy from the more active drive pool can be assigned to the less active one.

  • From the CommCell Browser, navigate to <Client> | PostgreSQL | <Instance>.

  • Right-click the FSBasedBackupSet, and then click All Tasks | Browse and Restore.

  • In the Browse and Restore Options dialog box, click View Content.

  • From the Browse window, select FSBasedBackupSet and click Recover All Selected.

  • In the PostgreSQL Database Restore Options dialog box, click Advanced.

  • In the Advanced Restore Options dialog box, click the Data Path tab.

  • Select the MediaAgent and Library from which you want to perform the restore.

  • Select the Drive Pool and Drive for tape library.

  • Click OK.

Refer to Change Data Path.

Encryption

If the client's data is encrypted with a pass phrase, you must enter the pass-phrase to start the data recovery operation. Follow the steps given below to enter the pass-phrase:

  1. From the CommCell Browser, navigate to <Client> | PostgreSQL | <Instance>.

  2. Right-click the FSBasedBackupSet, and then click All Tasks | Browse and Restore.

  3. In the Browse and Restore Options dialog box, click View Content.

  4. From the Browse window, select FSBasedBackupSet and click Recover All Selected.

  5. In the PostgreSQL Database Restore Options dialog box, click Advanced.

  6. In the Advanced Restore Options dialog box, click Encryption.

  7. Enter the Pass Phrase.

  8. Click OK.

Refer to Data Encryption.

Alerts

The Alert option is used for setting up the criteria to raise notifications/alerts for job statuses such as failure, success, or any other conditions triggered by the restore job. Adding alerts helps the user or the user group to get the notification automatically about the status of the restore job.

  1. From the CommCell Browser, navigate to <Client> | PostgreSQL | <Instance>.

  2. Right-click the FSBasedBackupSet, and then click All Tasks | Browse and Restore.

  3. In the Browse and Restore Options dialog box, click View Content.

  4. From the Browse window, select FSBasedBackupSet and click Recover All Selected.

  5. In the PostgreSQL Database Restore Options dialog box, click Advanced.

  6. In the Advanced Restore Options dialog box, click the Alert tab.

  7. Click Add Alert.

  8. From the Add Alert Wizard dialog box, select the Threshold and Notification Criteria. Click Next.

  9. Select the Notification Types. Click Next.

  10. Select the Users and User Groups. Click Next.

  11. Verify the Summary.

  12. Click Finish.

Refer to Alerts and Notifications.

CommCell Readiness Report

The CommCell Readiness Report provides you with vital information such as connectivity and readiness of the Client, MediaAgent, and CommServe. It is useful to run this report before performing a backup or a recovery operation. Follow the steps given below to generate the report:

  1. On the CommCell Console menu bar, select the Reports tab.

  2. Click Readiness.

    The Report Selection dialog box appears.

  3. If necessary, select Reports | CommServe | CommCell Readiness in the left pane.

  4. Select the Computers tab, and then click Modify below the Computers list.

  5. In the dialog box that appears, clear Include All Client Computers and All Client Groups.

  6. Select the appropriate client from the Exclude list, and then click Include >.

  7. Click OK.

  8. Select the MediaAgent tab, and then clear Include All MediaAgents.

  9. Select the appropriate MediaAgent from the Exclude list, and then click Include >.

  10. Click Run.

    The report appears in your default Web browser.

Refer to CommCell Readiness Report.

Restore Job Summary Report

The Restore Job Summary Report provides you with information about all the data recovery jobs that are run in last 24 hours for a specific client and agent. You can get information such as failure reason, failed objects, job options, and so on. It is useful to run this report after performing the restore. Follow the steps given below to generate the report:

  1. On the CommCell Console menu bar, select the Reports tab.

  2. Click Summary.

    The Report Selection dialog box appears.

  3. If necessary, select Reports | Jobs | Job Summary in the left pane.

  4. On the General tab, select Data Recovery Jobs.

  5. Select the Computers tab.

  6. Select the appropriate client and the appropriate agent.

  7. Click Run.

    The report appears in your default Web browser.

Refer to Restore Job Summary Report.

×

Loading...