Re: Lost Writes

  • From: Robert Freeman <robertgfreeman@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx, Richard.Goulet@xxxxxxxxxxx
  • Date: Thu, 6 Aug 2009 15:50:52 -0700 (PDT)

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

Other related posts: