Minimizing timeout 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 waiting for media or device access. If the delay is too long, the restore session times out. Use the following procedure to minimize session timeouts and to allow the restores to complete successfully.
To minimize timeout failures on large database restores
- In the NetBackup web UI, expand Hosts > Host properties.
- Select the client.
- If necessary, click Connect.
- Click Edit client.
- Click Timeouts.
- 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 Administrator's Guide, Volume 1.
For example, change this setting to 30-60 minutes to minimize timeout errors.
- Click 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.