Consistency checking tools? 
Author Message
 Consistency checking tools?
Can anyone advise me about what consistency checking tools/scripts exist

for oracle which can easily identify index and block integrity.
(Ideally looking for something like dbcc for sql server).

TIA
George Myers.



Wed, 20 Jun 2001 03:00:00 GMT
 Consistency checking tools?


(if that email address didn't require changing)

Quote:

>Can anyone advise me about what consistency checking tools/scripts exist

>for oracle which can easily identify index and block integrity.
>(Ideally looking for something like dbcc for sql server).

>TIA
>George Myers.

Not that you really ever need to do (i understand you must do dbcc for
sqlserver) it but...

SQL> analyze table validate structure cascade;

from sqlplus or dbv:

$ dbv help=y

DBVERIFY: Release 8.0.3.0.0 - Production on Sat Jan 2 17:45:40 1999

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Keyword   Description        (Default)
----------------------------------------------
FILE      File to Verify     (NONE)
START     Start Block        (First Block of File)
END       End Block          (Last Block of File)
BLOCKSIZE Logical Block Size (2048)
LOGFILE   Output Log         (NONE)
FEEDBACK  Display Progress   (0)

from the command line on a datafile.  Also, a full database export (not a backup
but exp) has pratically the same effect -- it fully tests the integrity of your
system tablespace as it pretty much reads the whole thing to export.  it tests
the integrity of your data (not indexes on your data necessarily) as it reads
all of it.  the thing I like about using export to do 'integrity' checks is that
I get yet another backup for emergencies and it doesn't lock anything (as
analyze will tend to do)....

Thomas Kyte

Oracle Service Industries
Reston, VA   USA

--
http://govt.us.oracle.com/    -- downloadable utilities

----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation

Anti-Anti Spam Msg: if you want an answer emailed to you,
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.



Wed, 20 Jun 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. consistency checking

2. Consistency check problem

3. Backups and consistency checks?

4. How to force consistency check failure?

5. Consistency checking

6. consistency check ?

7. script to check consistency between guc.h and postgresql.conf.sample

8. script to check consistency between guc.h and postg

9. script to check consistency between guc.h and postgresql.conf.sample

10. consistency checks

11. running dbcc (database consistency check) on Sybase via JDBC

12. Checking consistency...


 
Powered by phpBB® Forum Software