Re: Oracle database consistency checks

From: Gillian M <zmkj04_at_yahoo.com>
Date: Sat, 21 Oct 2000 11:42:56 -0700 (PDT)
Message-Id: <10656.119912@fatcity.com>

The Oracle DB has the SMON, PMON, CKPT, LGWR, DBWR, ARCH processes to do all its check, balances and keep it consistent. At the UNIX prompt do:
> ps -ef | grep <SID>

replace SID with whatever is the name of your database, and you will see all the processes out there running while the database is up.

There are no additional tools required.

G!
--- Jared Still <jkstill_at_bcbso.com> wrote: >
> 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
> jkstill_at_teleport.com - private
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>
> 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).

---

Received on Sat Oct 21 2000 - 13:42:56 CDT