Duleep wrote:

> I have had problems restoring some client databases due to corruption
> (Had to use data pump on many occasions)
>
> Is there a way of a smart backup to ensure that I can restore in the
> event of failures.

Right after you backup, you can restore to a temporary filename to check
it's good.

--
Milan Babuskov
http://njam.sourceforge.net
http://www.flamerobin.org