Re: [Veritas-bu] RMAN backup status

My 2 cents ...

The master server view of an Oracle Agent backup is just part of the story.

    * Your script/template can fail to perform one of its functions and
      not even try to backup something critical.  From the Master, the
      backup looks perfect.  As a minimum, you must have and
      periodically examine logs from your client backup scripts.
    * Your script/template might try to backup archive redo log files,
      but if rman finds none to be backed up, the backup, already
      started, is reported by the master as failed.

In the 1st case, the master is ignorantly optimistic; in the 2nd case, 
the master is ignorantly pessimistic.  Each case can probably be 
minimized by sufficient programming in the client script, but I'll guess 
that many or most scripts used today aren't perfect in this sense.

You might also want to look into RMAN's "RESTORE DATABASE VALIDATE;" as 
part of your verification of Oracle backups.  It doesn't physically 
write anything, but does at least some of what you seem to want to be 
able to confirm, albeit from a different perspective.

cheers, wayne

nbujohnson wrote, in part,  on 2009-01-13 1:49 PM:
> Thanks for the script Carl, but this is also a client based script which i 
> have to schedule on each db client .what i am looking here is a script which 
> i can scedule on my matser & which report all the rman failures 
> only,basically i need a single report which can be easily checked for all the 
> rman failures.
>
> 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