Oracle backup fails with EXIT STATUS 6: the backup failed to back up the requested files and File not found messages in the bphdb

Problem

Oracle backup fails with "EXIT STATUS 6: the backup failed to back up the requested files" and "File not found" messages in the bphdb.

Error Message

bphdb: FTL - Child exec of /usr/openv/nebackup/ext/scripts/ORACLEBACK_SCRIPT_NAME.sh failed.
bphdb: errno = 2: No such file or directory
bphdb: ERR - bphdb exit status = 29: the backup failed to back up the requested files

<4> bphdb: INF - EXIT STATUS 6: the backup failed to back up the requested files
<16> bphdb: ERR - Script exited with status = 29
 

bphdb shows "file not found" message.

Please note: /usr/openv/nebackup/ext/scripts/ORACLEBACK_SCRIPT_NAME.sh in the exact error message is the default location where NetBackup puts the.sh file, and this may not be the exact place the script will be located. Check with the System Administrator/DBA of the Server.

ORACLEBACK_SCRIPT_NAME.sh is a sample name, the actual script name will be dependent upon the Administrator/DBA in charge.

Solution

The Exit status in the Job Monitor fails with a Status 6, however, the ACTUAL exit code for the bphdb process is Status 29 which actually provides the pointer to what is wrong (e.g. "Failed trying to execute a command").

Check permissions on the script to ensure they are "owner oracle group dba   rwxr-xr-x"

Changing the permissions on the script enables the command to execute, therefore avoiding the error which is seen if the permissions on the script are incorrect.
 

Note:
This has been seen on Solaris platforms but may apply to other UNIX platforms too.