Oracle rman backup getting failed error code the backup failed to back up the requested files (6)

[mrauf]

Hello Experts,

i recently configured a oracle rman backup policy and configured the scripts while trigering the backup it's giving an error "the backup failed to back up the requested files (6) ".

-----------------------------------------------------------------------------------------------------------------------------------------------------

Master Server O/s :- Windows 2008 R2 64 Bit

Netbackup Version :- 7.6.1.1

Client Server o/s : - Linux 

Netbackup Version :- 7.6

-------------------------------------------------------------------------------------------------------------------------------------------------

please find the job details below

12/20/2018 3:24:36 PM - Info nbjm(pid=7136) starting backup job (jobid=1614318) for client client name, policy Policy Name, schedule Daily_CINCR
12/20/2018 3:24:36 PM - Info nbjm(pid=7136) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1614318, request id:{639A8666-010E-4C20-8F2C-823B3E4C50CD})
12/20/2018 3:24:36 PM - requesting resource Netbackup_MSDP_DiskPool_STU
12/20/2018 3:24:36 PM - requesting resource pbad-netbackup.pbad.sbg.com.sa.NBU_CLIENT.MAXJOBS.Client Name
12/20/2018 3:24:36 PM - requesting resource pbad-netbackup.pbad.sbg.com.sa.NBU_POLICY.MAXJOBS Policy Name
12/20/2018 3:24:36 PM - granted resource MasterServer.com.NBU_CLIENT.MAXJOBS.Client Name
12/20/2018 3:24:36 PM - granted resource MasterServer.com.NBU_POLICY.MAXJOBS.Policy Name
12/20/2018 3:24:36 PM - granted resource Netbackup_MSDP_DiskPool_STU
12/20/2018 3:24:37 PM - estimated 0 Kbytes needed
12/20/2018 3:24:37 PM - Info nbjm(pid=7136) started backup (backupid=Client Name_1545308676) job for client Client Name, policy Policy Name, schedule Daily_CINCR on storage unit Netbackup_MSDP_DiskPool_STU
12/20/2018 3:24:38 PM - started process bpbrm (8324)
12/20/2018 3:24:38 PM - Info bpbrm(pid=8324) Client Name is the host to backup data from
12/20/2018 3:24:38 PM - Info bpbrm(pid=8324) reading file list for client
12/20/2018 3:24:38 PM - connecting
12/20/2018 3:24:40 PM - Info bpbrm(pid=8324) starting bphdb on client
12/20/2018 3:24:40 PM - Info bphdb(pid=15063) Backup started
12/20/2018 3:24:40 PM - Info bphdb(pid=15063) Processing /opt/Symantec/sc/ScriptName.sh
12/20/2018 3:24:40 PM - Info bphdb(pid=15063) Waiting for the child status
12/20/2018 3:24:40 PM - connected; connect time: 0:00:02
12/20/2018 3:24:41 PM - Error bpbrm(pid=8324) from client Client Name: ERR - Script exited with status = 29 <failed trying to exec a command>
12/20/2018 3:24:41 PM - Error bpbrm(pid=8324) from client Client Name: ERR - bphdb exit status = 6: the backup failed to back up the requested files
12/20/2018 3:24:46 PM - Info bphdb(pid=15063) done. status: 6: the backup failed to back up the requested files
12/20/2018 3:24:46 PM - end writing
the backup failed to back up the requested files (6)

Please help me resolve the issue as soon as possible.

[Marianne]

There is a problem in the script:

Error bpbrm(pid=8324) from client Client Name: ERR - Script exited with status = 29 <failed trying to exec a command>

Status 29 is normally a user permission issue.

If the job is started from the scheduler on the master, the script on the client will be run as root. For this reason you need to add 'su - <oracle-user>' in the script.

Please compare the backup script with the sample scripts in /usr/openv/netbackup/ext/db_ext/oracle/samples/rman.

Extract from sample  hot_database_backup.sh :

if [ "$CUSER" = "root" ]
then
    su - $ORACLE_USER -c "$CMD_STR" >> $RMAN_LOG_FILE
    RSTAT=$?
else
    /usr/bin/sh -c "$CMD_STR" >> $RMAN_LOG_FILE
    RSTAT=$?
fi

[Amol_Nair]

Also do check if you have provided the correct oracle home path and the correct oracle user in the script..

If the oracle home path is incorrect, while executing the script it would not find the rman binary to execute and may report such errors.

To start with I would say create the bphdb log on the client machine and run the backup you should be able to get the problem.

[mrauf]

Hi Marianne,

After given user permission we are getting the same error and the issue is still persists. 

12/24/2018 12:20:18 PM - Info nbjm(pid=7100) starting backup job (jobid=1616624) for client Client Name, policy Policy Name, schedule Daily_CINCR 
12/24/2018 12:20:18 PM - Info nbjm(pid=7100) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1616624, request id:{49D90A9F-02AB-4850-AD52-1A86E76D0DB1}) 
12/24/2018 12:20:18 PM - requesting resource Netbackup_MSDP_DiskPool_STU
12/24/2018 12:20:18 PM - requesting resource Master Server Name.NBU_CLIENT.MAXJOBS.Client Name
12/24/2018 12:20:18 PM - requesting resource Master Server Name .NBU_POLICY.MAXJOBS.Policy Name
12/24/2018 12:20:18 PM - granted resource Master Server Name.NBU_CLIENT.MAXJOBS.Client Name
12/24/2018 12:20:18 PM - granted resource Master Server Name.NBU_POLICY.MAXJOBS.Policy Name
12/24/2018 12:20:18 PM - granted resource Netbackup_MSDP_DiskPool_STU
12/24/2018 12:20:19 PM - estimated 0 Kbytes needed
12/24/2018 12:20:19 PM - Info nbjm(pid=7100) started backup (backupid=Client Name_1545643218) job for client Client Name, policy policy Name, schedule Daily_CINCR on storage unit Netbackup_MSDP_DiskPool_STU
12/24/2018 12:20:19 PM - started process bpbrm (8584)
12/24/2018 12:20:20 PM - Info bpbrm(pid=8584) Client Name is the host to backup data from 
12/24/2018 12:20:20 PM - Info bpbrm(pid=8584) reading file list for client 
12/24/2018 12:20:20 PM - connecting
12/24/2018 12:20:21 PM - Info bpbrm(pid=8584) starting bphdb on client 
12/24/2018 12:20:21 PM - connected; connect time: 0:00:01
12/24/2018 12:20:22 PM - Info bphdb(pid=18692) Backup started 
12/24/2018 12:20:22 PM - Info bphdb(pid=18692) Processing /opt/Symantec/sc/mobiledb.sh 
12/24/2018 12:20:22 PM - Info bphdb(pid=18692) Waiting for the child status 
12/24/2018 12:20:23 PM - Error bpbrm(pid=8584) from Client Name: ERR - Script exited with status = 127 <specified media or path does not contain a valid NB database backup header>
12/24/2018 12:20:23 PM - Error bpbrm(pid=8584) from client Client Name: ERR - bphdb exit status = 6: the backup failed to back up the requested files
12/24/2018 12:20:32 PM - Info bphdb(pid=18692) done. status: 6: the backup failed to back up the requested files 
12/24/2018 12:20:32 PM - end writing
the backup failed to back up the requested files (6)

[mrauf]

Hi Amol,

were should we give the home path if can u discribe me in details it's helpful for me, becoz i am new in oracle.

Thanks

[Amol_Nair]

The error shared now is not the same ad earlier.. earlier it was reporting a status 29 and the new job details have the error 127..

could you share the logs that are generated under the bphdb log folder on the client.

The oracle home path would be set in the script that you are using

[Marianne]

The error is most certainly not the same (you can ignore the status 6).

Your dba needs to compare his script with the sample script.
There is still a script error:

"Script exited with status = 127 <specified media or path does not contain a valid NB database backup header>"