NetBackup™ for Greenplum Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (11.0)
  1. Introducing NetBackup for Greenplum
    1.  
      About NetBackup for Greenplum
    2.  
      NetBackup for Greenplum terminology
    3.  
      Features of NetBackup for Greenplum
    4.  
      NetBackup for Greenplum technical overview
    5.  
      Sequence of operation for NetBackup for Greenplum backups
  2. Installing NetBackup for Greenplum
    1.  
      Verifying the operating system and platform compatibility
    2.  
      NetBackup server and client requirements
    3.  
      Greenplum server software requirements
  3. Configuring NetBackup for Greenplum
    1.  
      About NetBackup for Greenplum configuration
    2. About configuring a backup policy for Greenplum
      1.  
        Adding a NetBackup for Greenplum policy
      2.  
        About policy attributes
      3.  
        Schedule properties
      4. NetBackup for Greenplum backup types
        1.  
          Configure an application backup schedule
        2.  
          Example application backup schedule
        3.  
          Configure automatic backup schedules
        4.  
          Example automatic backup schedule
      5.  
        Add clients to a policy
      6.  
        Adding NetBackup for Greenplum scripts to the backup selections list
    3. About the backup script for NetBackup for Greenplum
      1.  
        Modify the backup script for NetBackup for Greenplum
    4.  
      Best practices for Greenplum backups
    5.  
      Configuration options for backup jobs
    6.  
      Use of the --jobs option or backup streams and the effect on NetBackup jobs and throttling options
    7.  
      The nbgpbackup_config.yaml file
    8.  
      About permissions for NetBackup for Greenplum log files
    9.  
      Perform a manual backup
  4. Using NetBackup for Greenplum
    1.  
      About Greenplum database backups
    2.  
      Perform a user-directed backup for Greenplum
    3. About restoring a Greenplum database
      1.  
        Restore a Greenplum database
      2.  
        Redirect a restore to a different Greenplum configuration
  5. Troubleshooting NetBackup for Greenplum
    1. NetBackup debug logs and reports
      1.  
        Enabling the debug logs manually
      2.  
        About the bphdb directory on the database client
      3.  
        Setting the debug level
      4.  
        About NetBackup server reports
    2.  
      Minimizing time-out failures on large database restores
    3.  
      Troubleshooting of Greenplum backups that are canceled mid-backup
  6. Appendix A. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

Minimizing time-out failures on large database restores

Large database restores sometimes fail when multiple restore sessions compete for resources. In this situation, a restore session can be delayed while NetBackup waits for media or device access. If the delay is too long, the restore session times out. Use the following procedure to minimize session time-outs and to allow the restore jobs to complete successfully.

To minimize time out failures on large database restores

  1. Open the NetBackup web UI.
  2. On the left, select Hosts > Host properties.
  3. Select the check box for the client.
  4. If necessary, select Connect.
  5. Select Edit client.
  6. Select Timeouts.
  7. Set the Client read timeout property to a large value.

    The default for the Client read timeout setting is 300 seconds (5 minutes). For database agent clients, increase the value significantly from the recommended value.

    See the NetBackup Web UI Administrator's Guide.

    For example, change this setting to 30-60 minutes to minimize time-out errors.

  8. Select Save.

Note:

This change may delay detecting problems during subsequent backups. Consider putting the original value back in place once any restore that requires a change is complete.