I don't really have the time to custom script anything for you but I'd
run something like this.

Capture the output of bpdbjobs -all_columns (This comes out comma
delimited)
I put this into SQL to be referenced later, but a simple scripted array
would work for this purpose.

The 21st column is the subtype - so look for subtype 2 which are user
backups
Then parse for the 22nd column which is class type - look for values of
4 which are Oracle policies
Then parse for the 4th column, which is status - look for status != 0.

You can then use the other fields:

5 - policy
6 - schedule
7 - client
8 - master
9 - start time

To create a pretty report for the DBAs.

-Jonathan

-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of
nbujohnson
Sent: Wednesday, January 14, 2009 1:37 PM
To: VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] RMAN backup status


I need a report which can list backup status of db clients from
netbackup,i know it will report status 6 for most of the rman failure
but thats ok,it will  tell me which db backup got failed so that i can
check the respective rman output file & notify my dba's.

Thanks,
John

+----------------------------------------------------------------------
|This was sent by nbujohnson AT googlemail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu