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??
Status 6 points to an issue with the the script.
Troubleshooting must start with checking the actual script and the script output.
Status 6 points to an issue with the the script.
Troubleshooting must start with checking the actual script and the script output.
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)
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?
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.
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.
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
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.
Marianne for the win!
Yeah Marianne., You are right :)
