Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to make sure I don't write a corrupt page to db when I checkpoint?

Re: How to make sure I don't write a corrupt page to db when I checkpoint?

From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Mon, 02 Jul 2007 01:06:55 GMT
Message-ID: <PcYhi.2721$rR.1794@newsread2.news.pas.earthlink.net>


Sune wrote:

>> Then you run the risk of corruption.

>
> Yupp, any suggestions?

checksums?

As in, a process that modifies a page has to generate a checksum for the modified page, and the process that writes the pages (is there one - it's an in-memory database) has to lock the page and verify the checksum (and, maybe, worry about whether a process modified the page while it was locked by ignoring the lock).

In the context of a DBMS, paranoia is good. Just because you can't see that the processes attached to the database aren't out to make life difficult for you doesn't mean they aren't going to make difficult for you anyway.

-- 
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/
Received on Sun Jul 01 2007 - 20:06:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US