Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Checking RMAN backup results

RE: Checking RMAN backup results

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 17 Sep 2003 06:29:40 -0800
Message-ID: <F001.005D0397.20030917062940@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US