Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Checking RMAN backup results
Rich,
I parse the Rman output using Perl and look for "RMAN-00569" in the output file. If I find it, then I send email to myself with a subject line indicating that the backup failed.
Pretty simple. And it's been working well for a few years now.
The Perl script is available free. Just email me off-line.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, September 17, 2003 2:39 AM
To: Multiple recipients of list ORACLE-L
Posted on behalf of Rich Holland (holland_at_guidancetech.com):
> Apparently my ISP went off-line for a couple days, and my
> oracle-L mailing list subscripshun [purposefully spelled
> incorrectly to avoid the listmangler filters -rjh] was moved
> to the bounced mailing list.
>
> Below is a message I sent on 9/10. I tried searching the
> online archives @ ListGuru and orafaq with no luck (I can't
> even find my original posting from 9/10, let alone any
> replies).
>
> If you replied, can you re-send your response via email? I'd
> greatly appreciate it...
>
> Thanks!
> Rich
> --
> Rich Holland holland_at_guidancetech.com SAP Technical Consultant
> print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");
>
> > -----Original Message-----
> > Sent: Wednesday, September 10, 2003 11:13 AM
> > Subject: Checking RMAN backup results
> >
> > Before I reinvent the wheel, I thought I'd ping the list to see how
> > other folks are validating their RMAN backups. In other
> words, when
> > your backup_full script runs, do you just parse the results looking
> > for RMAN-#### or ORA-#### errors, "Backup completed
> successfully" etc?
> >
> > Or do you run a validate step and process that?
> >
> > What's the general consensus on automating backup checking?
> I'd like
> > to just be emailed when there's a problem, rather than doing manual
> > checks every day for the previous night's backups.
> --
> Rich Holland (913) 645-1950 SAP Technical Consultant
> print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");
>
> ----- end returned message -----
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: bruceb_at_fatcity.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Sep 17 2003 - 09:29:40 CDT