SAP Agent Restore: Control File is corrupted in a restore job and database cannot be started if the backup job used software compression

Article:TECH68695  |  Created: 2009-01-12  |  Updated: 2014-05-14  |  Article URL http://www.symantec.com/docs/TECH68695
Article Type
Technical Solution


Issue



SAP Agent Restore: Control File is corrupted in a restore job and database cannot be started if the backup job used software compression


Cause



If SAP data is backed up with software compression enabled, the following problems may occur when the SAP database is restored:
  • The control file is corrupted.
  • The database cannot be started.
These issues have been seen when the following conditions exist:
 
  • SAP is used with the Oracle database.
  • The Backup Exec Agent for SAP Applications is used for the backup job with software compression enabled.

Solution



Workaround:
To prevent these issues from occurring, ensure that software compression is not enabled in the template for DBA-initiated backup jobs. If software compression is enabled and the control file is corrupt, the control file must be restored manually. To manually restore the control file:
1. On the computer where the Backup Exec Agent for SAP Applications is installed, shut down the SAP database.
2. On the Backup Exec navigation bar, click the arrow next to Restore.
3. Click New Restore Job.
4. Click Selections.
5. Select the control file in the backup sets for SAP. The control file is usually found at the following path: \\Machine_Name\c$\oracle\cer\sapdata1\cntrl\ctrlcer.ctl
6. Restore the control file over the corrupt control file.
7. Copy the control file to the other configured locations of the control file. Oracle usually has three control files. The usual locations of the control files are as follows:
 - \\<machine name>\c$\oracle\cer\sapdata2\cntrl\ctrlcer.ctl
 - \\<machine name>\c$\orcle\cer\saparch\cntrl\ctrlcer.ctl
 
8. On the computer where the Backup Exec Agent for SAP Applications is installed, bring the database up.  
 
Solution:  
This issue has been resolved in Backup Exec for Windows Server version 12.5.

Supplemental Materials

Value1196593
Description

SAP Agent: Control file gets corrupted in a restore job when backup used compression

 



Legacy ID



320935


Article URL http://www.symantec.com/docs/TECH68695


Terms of use for this information are found in Legal Notices