Nice blog post.... :-) RF Robert G. Freeman Oracle ACE Author: Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press) Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press) Other various titles out of print now... Blog: http://robertgfreeman.blogspot.com The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-) http://pages.sssnet.com/messndal/church/parachurch.pdf ________________________________ From: Jared Still <jkstill@xxxxxxxxx> To: Richard.Goulet@xxxxxxxxxxx Cc: charlottejanehammond@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx; Mark W. Farnham <mwf@xxxxxxxx> Sent: Thursday, August 6, 2009 4:39:33 PM Subject: Re: Lost Writes On Thu, Aug 6, 2009 at 8:25 AM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx> wrote: > >Charlotte, > >> Best idea in this case is to check that all of your data is available >> and the best way that I know of to do that is to do an exp full=yes to >> /dev/null. If that finishes cleanly then your 99% sure that everything is >> alright. After that I would take another backup. > > While a successful export is a fairly good indicator that the database is ok, it doesn't necessarily indicate that there are no bad blocks in the database. It was a rather interesting topic, it even seemed blogworthy: :) http://jkstill.blogspot.com/2009_08_01_archive.html Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist