Re: Oracle database consistency checks

Other databases require and use these 'repair' utilities due to their strange architecture of locating the data dictionary in a database other than the one where the data is.

At least that's the way it was explained to me.

I'll know more after my Sybase classes next week.

Jared

On Mon, 9 Oct 2000, Koen Lefever wrote:

> Hi,
>
> I have some general questions on how Oracle manages consistency, in comparison to other RDBMSes.
>
> Other RDBMS systems have dedicated programs to check the consistency of the database
> (like oncheck for Informix or dbcc for Sybase) and sometimes tools to correct inconsistencies.
> I mean consistency on physical level: pointers between rows, pages, files, etc...
> I'm not aware of such a tool on Oracle.
>
> 1. Does Oracle perform such checks/repairs automatically?
> 2. Are there any Oracle or third party tools to perform such checks?
> 3. Do I need them? I've never had a "broken chain" or "corrupt page" on Oracle.
> Am I just lucky or is this an example of a superior architecture?
> 4. If such a problem would occur, what can I do except for a full restore?
>
> All links to web pages, books, trainings... where I can find more information on this are welcome.
>
> aTdHvAaNnKcSe & Best regards,
> Koen.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Koen Lefever
> INET: Koen.Lefever_at_dexia.be
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue Oct 10 2000 - 15:16:54 CDT