Re: queries on db corruption..

From: PhilB <phillip.bridges_at_gmail.com>
Date: 25 Jul 2005 07:53:10 -0700
Message-ID: <1122303190.633028.103670@g49g2000cwa.googlegroups.com>

1. depends on what the object is, if its an index, Oracle MAY decide to talk you through dropping it and recreating it using the data dictionary creation scripts. If its a table, you dont have much option other than to recreate the database from whatever backup you have.
2. You cant avoid corruption, you can only minimize the risk of loss of data by having a proper DR plan.

However, regular checks for corruption can be done using the analyze table command :-

ANALYZE TABLE/INDEX/CLUSTER ... VALIDATE STRUCTURE Also dbverify on offline files which will scan all blocks in a datafile and report on possible corruption :-

/home/oracle92$ dbv help=y

DBVERIFY: Release 9.2.0.4.0 - Production on Mon Jul 25 15:49:59 2005

Copyright (c) 1982, 2002, 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)
PARFILE     Parameter File                 (NONE)
USERID      Username/Password              (NONE)

SEGMENT_ID Segment ID (tsn.relfile.block) (NONE)

Phil. Received on Mon Jul 25 2005 - 09:53:10 CDT