Video Screencast Help

Notifications backup errors for SQL/ORACLE Policy

Created: 10 Oct 2012 • Updated: 11 Oct 2012 | 6 comments
This issue has been solved. See solution.

Hi

Sorry for my bad English.

We use NetBackup 7.5.0.4 installed on a Windows Server 2008 R2 SP1.

We want to be notified by email each time a backup error occurs.

We followed the documentation. Notification in case of error works very well for our backup jobs VMware, Windows Server, Linux Server, and Lotus

Blat is OK, nbmail.cmd is OK

But

Notifications do not work for our backup jobs SQL and ORACLE : " Error bpbrm(pid=4404) cannot send mail to.... "

If we configure the client properties (Oracle or SQL) / universal Setting / Client Sends mail: mails we receive even if the backup is successful.

We backup SQL log every 30 min. We do not want to receive mail every 30 minutes! We just want to receive a mail if a backup fails.

 

Can you help us ?

 

Thank

Comments 6 CommentsJump to latest comment

MilesVScott's picture

What documentation did you follow and What specifically is alerting you?

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

vburgun's picture

Hi,

Thank you for your help.

I use this topic:

- For blat

http://www.symantec.com/business/support/index?pag...

- For nbmail

http://www.symantec.com/business/support/index?pag...

- and this topic

http://www.symantec.com/business/support/index?pag...

As explain in the last topic, I want to receive one email for every failed backup.

For my SQL and ORACLE backup, I don' receive any email when i have failed backup (but it works for my all my other policy).

For my SQL and ORACLE, if i have failed backup, I can see on activity monitor " Error bpbrm(pid=4404) cannot send mail to.... "

 

RLeon's picture

I recommend using Netbackup OpsCenter (Free) for this kind of tasks. Just don't install it on the same server as your Master server, if you can.

MilesVScott's picture

I would agree with RLeon. OpsCenter or if available OpsCenter Analytics, provide excellent reporting and alerting for NetBackup policies.

 

Here is some good documnetation on OpsCenter, and the differences between the free version and Analytics.

 

http://eval.symantec.com/mktginfo/enterprise/white_papers/b-nbu_7_opscenter_analytics_WP.en-us.pdf

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

vburgun's picture

Thank you for your Help

We have a licence for OpsCenter Analytics.

We use only OpsCenter for report.

I did not know you could generate real-time alerts for job backup.

Now, I use "Alert policies".

I use this alert :

"Job finalized : An alert is generated when a job of a....."

and I use this fonction:

"If specified, alert is generated for jobs whose exit status doesn't match the exit status specified below."

On "Exit Status to Exclude:", I write "0"

And now it's OK!!

 

Thank you!

 

 

 

SOLUTION
MilesVScott's picture

Glad you were able to figure it out!

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist