Oracle 3Par/ZDB backup sessions hang during DP managed Control file backup

  • KM02741527
  • 27-Feb-2017
  • 27-Feb-2017

Summary

DP managed control file is an optional object backup. If such option is enabled, DP triggers this object backup when he receives a signal from RMAN/Oracle indicating that all the objects composing the database were backed up successfully. In very slow environment such signal may arrives after a too long media agent period of inactivity.

Error

No error message - only hang during DP managed control file backup

Cause

DP managed control file is an optional backup object. If such option is enabled,  DP triggers this object backup when he receives a signal from RMAN/Oracle indicating  that all the objects composing the database were backed up successfully. In this customer situation, the environment was so slow that such signal arrives after more than 30 minutes of Data Protector media agent inactivity. Data Protector by default assumes that after 10 minutes of media agent inactivity such agent can be stopped.

Fix

Solution is to increase the BackupDeviceIdle variable value to  1 hour.
However, such slow environment should be invetsigated and corrected as it may lead to other problems.