05-07-2013 09:39 AM
Hi All,
I faced an issue with backup for oracle.
Master server windows 2008 r2 with version 7.5.0.4
media server (appliance 5220) version 2.5
client Solaris Sparc
I installed the agent then configured one policy for os backup it was succeded and all conecctifity test were responed normally from all sides.then i completed the link with rman then I asked the Oracle admin to modify the hotbackup script then i configured an oracle policy and used ths script and when i run the job failed:
5/7/2013 3:27:12 PM - Info nbjm(pid=3436) starting backup job (jobid=390) for client oraapps1.moc.gov.sa, policy Oracle_test, schedule at
5/7/2013 3:27:12 PM - Info nbjm(pid=3436) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=390, request id:{4269F815-2B00-415A-AA5D-3E5384EB5615})
5/7/2013 3:27:12 PM - requesting resource stu_disk_nbumedia
5/7/2013 3:27:12 PM - requesting resource symbkp.moc.gov.sa.NBU_CLIENT.MAXJOBS.oraapps1.moc.gov.sa
5/7/2013 3:27:12 PM - requesting resource symbkp.moc.gov.sa.NBU_POLICY.MAXJOBS.Oracle_test
5/7/2013 3:27:12 PM - granted resource symbkp.moc.gov.sa.NBU_CLIENT.MAXJOBS.oraapps1.moc.gov.sa
5/7/2013 3:27:12 PM - granted resource symbkp.moc.gov.sa.NBU_POLICY.MAXJOBS.Oracle_test
5/7/2013 3:27:12 PM - granted resource stu_disk_nbumedia
5/7/2013 3:27:12 PM - estimated 0 Kbytes needed
5/7/2013 3:27:12 PM - Info nbjm(pid=3436) started backup (backupid=oraapps1.moc.gov.sa_1367929632) job for client oraapps1.moc.gov.sa, policy Oracle_test, schedule at on storage unit stu_disk_nbumedia
5/7/2013 3:27:13 PM - started process bpbrm (25383)
5/7/2013 3:27:14 PM - Info bpbrm(pid=25383) oraapps1.moc.gov.sa is the host to backup data from
5/7/2013 3:27:14 PM - Info bpbrm(pid=25383) reading file list from client
5/7/2013 3:27:14 PM - connecting
5/7/2013 3:27:14 PM - connected; connect time: 00:00:00
5/7/2013 3:27:15 PM - Info bpbrm(pid=25383) starting bphdb on client
5/7/2013 3:27:15 PM - Info bphdb(pid=14037) Backup started
5/7/2013 3:27:15 PM - Info bphdb(pid=14037) Processing /apps
5/7/2013 3:27:15 PM - Info bphdb(pid=14037) Waiting for the child status
5/7/2013 3:27:16 PM - Error bpbrm(pid=25383) from client oraapps1.moc.gov.sa: ERR - Script exited with status = 29 <failed trying to exec a command>
5/7/2013 3:27:16 PM - Info bphdb(pid=14037) Processing /u02/app/oracle/product/11.2.0/dbhome_1/hot_database_backup.sh
5/7/2013 3:27:16 PM - Info bphdb(pid=14037) Waiting for the child status
5/7/2013 3:27:17 PM - Error bpbrm(pid=25383) from client oraapps1.moc.gov.sa: ERR - Script exited with status = 29 <failed trying to exec a command>
5/7/2013 3:27:17 PM - Error bpbrm(pid=25383) from client oraapps1.moc.gov.sa: ERR - bphdb exit status = 6: the backup failed to back up the requested files
5/7/2013 3:27:17 PM - Info bphdb(pid=14037) done. status: 6: the backup failed to back up the requested files
5/7/2013 3:27:17 PM - end writing
the backup failed to back up the requested files(6)
Solved! Go to Solution.
05-16-2013 08:06 AM
I added the following lines in the bp.conf in the client machine.and it works fine now.
setenv NB_ORA_POLICY policyname
setenv NB_ORA_SCHED application_backup_schedule_name
setenv NB_ORA_SERV NetBackup_server
Regards,
05-07-2013 11:16 AM
Status 29 : http://www.symantec.com/docs/HOWTO34915
Script exited with status = 29 <failed trying to exec a command>
The script run had an error - try running it by hand and observe output error including warnings, bad options or qualifiers (bad format date for example). Check permissions as well.
05-07-2013 11:21 AM
Review the dbclient log on the client machine for clues. If you still have trouble, post your script and dbclient log as attachments so we can see what the cause might be.
05-14-2013 10:22 AM
FYI,
I used rman script located in the client then i added to the oracle policy in selection,I confused if ths make sense or not ,where the master is windowd machine(script.cmd) and the client unix machine(script.sh).
The other thing can I get more details about permission? what permission you mean exactly?sysdba?
Regards,
05-16-2013 08:06 AM
I added the following lines in the bp.conf in the client machine.and it works fine now.
setenv NB_ORA_POLICY policyname
setenv NB_ORA_SCHED application_backup_schedule_name
setenv NB_ORA_SERV NetBackup_server
Regards,