RE: Checking RMAN backup results

 Alghough I use the RMAN catalog and so backup success/failure can be seen from there. I find it easiest to write out a log of the entire backup process in my "calling" script to a specific directory /dblogs/backups

All my backup scripts are written their with date/timestamp in the name along with database name.

At the end of the backup I parse out the word "SUCCESS" or "FAILURE" with the same Unix commands and sent mails.

Eventually I want to write a process that looks at the logs for all the backups for a particular date which I will run each night and sends a comprehensive list which would be compared against a list of all the databases I administer.

I have written the scripts to basically run just passing parameters - so I utilize the same stored scripts, I have uniquely named "call scripts" which only pass database name.

Then I run some basic rman "call" scripts for various types of backups. Everything has been running like a charm for years now and this approach has made it very easy to support multiple catalogs in one database or multiple rcat catalogs.

If you would like I could send you some examples. I know others have posted their rman stuff which I keep telling myself I will have time to look at. Probably some along the same lines.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 9/17/03 2:39 AM

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: 
  INET: Paula_Stankus_at_doh.state.fl.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).