08-29-2015 08:54 PM
Oracle backup is failing with 6 error code,
In the detailed status I can see this error:
Error bpbrm (pid=2845) from client xxxxxxxxxx-be: ERR - Script exited with status = 126 <NB database backup header is too large, too many paths specified>
Can you please provide is there anything need to be verified from NBU end??
Solved! Go to Solution.
08-31-2015 01:25 AM
Status 6 points to an issue with the the script.
Troubleshooting must start with checking the actual script and the script output.
08-31-2015 01:25 AM
Status 6 points to an issue with the the script.
Troubleshooting must start with checking the actual script and the script output.
08-31-2015 04:49 AM
From the Oracle RMAN logs - I can see this error:
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 :-- Oracle RMAN backup --------------
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 :-- Oracle instance ='FEPA':'/app/oracle/11.2.0/db_4' autostart='Y'
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 : Started RMAN for ORACLE_SID='FEPA'
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 : SBTPARMS=NB_ORA_SID=FEPA,NB_ORA_CLIENT=xxxxxxxxxxxx,NB_ORA_POLICY=xxxxxxxxxxxxxx
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 : /home/oracle/rman/rman_backup.sh backup_db_Hourly_archivelogs FEPA USECATALOG
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 :--- Ended RMAN with rc='126' for ORACLE_SID='FEPA'
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 : Netbackup policy 'xxxxxxxxxxxxxxxxxxxxxxxx' schedule 'HOURLY1' failed for 'FEPA'
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 : Check '2015-08-27-120624' rman logs file /data/ora/FEPA/admin/rman/logs
Aug 27 12:06:24 xxxxxxxxxxxx Netbackup HOURLY1 JobId=620855 :== FAILED Netbackup Job with rc='126' (started at 2015-08-27-120624)
08-31-2015 07:43 AM
There seems to be another RMAN log file:
Check '2015-08-27-120624' rman logs file /data/ora/FEPA/admin/rman/logs
Can you please check and confirm?
08-31-2015 11:31 AM
Are you using files per set in the rman archive backup script ?
To me the error sounds like rman is trying to backup too many archive files at once.
Besides the rman log, the Oracle alert log often contains indications of what problem is.
08-31-2015 01:11 PM
1 - has this worked before?
2 - if so, what has changed?
error 6 is a generic response, you always have to review the oracle logs.
Based on the error, you can review the policy to ensure the storage works.
If it is a new script, review the .sh and .rcv files, since 99% of the time, there is a typo, or a missplaced variable.
10-05-2015 04:48 AM
Thanks all for your valuable suggestion.,
Issue was with rman backup script - Its a customized script - one of the script function is missing., Oracle team copied & pasted the backup script from the working server & it went successful
10-05-2015 08:50 AM
LOL, please mark my response as solution:
If it is a new script, review the .sh and .rcv files, since 99% of the time, there is a typo, or a missplaced variable.
10-05-2015 11:23 AM
10-05-2015 12:24 PM
Marianne for the win!
10-06-2015 09:13 AM
Yeah Marianne., You are right :)
10-06-2015 01:39 PM