Re: Saving Backup Errros inside the db

Greetings,

Thank you all for your reply...

We have a mix of Oracle version starting from 8.1.7

Right now I have a few lines in the RMAN Hotbackup script that extracts the info (success or error) from the RMAN log and write into on my tables with the following info:

hostname, instance_name, start_time, end_time, status (varchar2(4000))

# Start of Code
HOST=$(hostname)
PROGRAM=${0##*/}
START_TIME=$(date '+%m/%d/%y %X')
BACKUP_LOGFILE="..../.../rman_backup.log"

exec 2>&1 >> $BACKUP_LOGFILE

RMAN Backup commands {}

END_TIME=$(date '+%m/%d/%y %X')

STATUS=$(awk '/ERROR MESSAGE STACK FOLLOWS/,/RMAN>/ {print $0}'

        I was under the impression that this was already stored or is that
> only under 10g and with central catalog? I just remember reading something
> about this in a tech doc somewhere.
>
> Rgds
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Grant Allen
> Sent: 28 Dec 2005 7:34
> To: bnsarma_at_gmail.com
> Cc: lazydba
> Subject: Re: Saving Backup Errros inside the db
>
>
> BN wrote:
>
> > Greetings,
> >
> > I would like to save the following RMAN error messages inside a table
> > along with the timestamp
> >
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> >
> [snip]
>
> > Can somebody suggest me how I can do this. I want to save the new
> > lines, as they appear in the error message.
> >
> > Am I looking at a CLOB or do I have other options.
>
>
> BN - others are already suggesting the post-backup shell script, but you
> do have options other than CLOB. You can save the new lines with some
> easy regex work and the ever-useful chr(10) or chr(13)||chr(10) trick
> (depending on your OS). This means you can opt for char or varchar2,
> which you might find *much* easier to use in the long run.
>
> Ciao
> Fuzzy
> :-)
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> ****************************************************************************
> This message contains confidential information and is intended only
> for the individual or entity named. If you are not the named addressee
> you should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have received
> this e-mail by mistake and delete this e-mail from your system.
> E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted, corrupted, lost, destroyed, arrive
> late or incomplete, or contain viruses. The sender therefore does not
> accept liability for any errors or omissions in the contents of this
> message which arise as a result of e-mail transmission.
> If verification is required please request a hard-copy version.
> This message is provided for informational purposes and should not
> be construed as an invitation or offer to buy or sell any securities or
> related financial instruments.
> GAM operates in many jurisdictions and is
> regulated or licensed in those jurisdictions as required.
>
> ****************************************************************************
>
>

--
Regards & Thanks
BN