Codasyl DBMS Recovery - Another Option

From: nntp.ix.netcom.com <envy_at_ix.netcom.com>
Date: Sun, 9 Aug 1998 14:58:05 -0700
Message-ID: <6ql6cm$av6@dfw-ixnews10.ix.netcom.com>

Database Recovery--Another Option

We have developed a program which can be used to assist in the recovery of certain types
of Codasyl DBMS database corruption (old corruption and/or data with no backups or AIJs).

The program uses DBALTER to remove the SET TYPE pointer cluster from the page's line index.
DBKEY removal occurs by changing/moving the pointer cluster/line index offsets up the
page, thus overwriting the unwanted cluster. The program updates the page's free space,
line index count, starting/ending line offsets and checksum page structures.

An example for using this tool, a DBO/INIT was executed on a storage area without FIRST disconnecting cross-area pointers.

The program is available as a free download on http://www.envysys.com. The program is
located in the DOWNLOAD section.

CAUTIONARY NOTE:
You should always consult Oracle Technical Support prior to using DBALTER on any
database. Received on Sun Aug 09 1998 - 16:58:05 CDT