Redirected SAP Agent restore fails after restoring the database files with: Read access to /database-path/<sid>/sapbackup/cntrl<sid>.dbf was denied

Article:TECH54998  |  Created: 2007-01-26  |  Updated: 2009-01-10  |  Article URL http://www.symantec.com/docs/TECH54998
Article Type
Technical Solution


Environment

Issue



Redirected SAP Agent restore fails after restoring the database files with: Read access to /database-path//sapbackup/cntrl.dbf was denied

Error



the restore failed to recover the requested files

Solution



ISSUE: Attempts to redirect an SAP backup to an alternate client fail with a NetBackup Status Code 5 (the restore failed to recover the requested files).  A review of the backint log file shows access denied error messages.  

ERROR CODE/MESSAGE:
NetBackup Status Code 5 (the restore failed to recover the requested files).  

ENVIRONMENT/CONDITIONS: N/A

EVIDENCE:

Review the backint file for error messages similar to the following:
[827642.00] 15:52:22 (590994.003) Read access to /oracle/SP1/sapbackup/cntrlSP1.dbf was denied
[827642.00] 15:52:22 (590994.003) INF - TAR EXITING WITH STATUS = 0 [827642.00] 15:52:22 (590994.003) INF - TAR RESTORED 31 OF 32 FILES

SOLUTION/WORKAROUND: When performing an SAP redirected restore, the user ID being used for the restore must have read permissions to the backup information and write permissions to the target location.  Usually, the user id and group id are the same, but sometimes this is not possible. In these cases, the user id or group id needs to have permissions as described above because of the way the original user saves the data during the backup.

If this error occurs, it is possible to restore the controlfile using the bprestore command (running as root) to recover the missing files, then manually copying them to the location necessary for the new database.

REFERENCE: N/A


Legacy ID



293394


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


Terms of use for this information are found in Legal Notices