]
[EMAIL PROTECTED]cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
om Subject: quckways to find
block corruption
Sent by:
[EMAIL PROTECTED]
23-09-2002 12:03
Hello all,
DB: 8i
OS: solaris 2.7
can somebody post me reply for this.
is there any quick way to find which datablocks are
corrupted in my oracle database .
( other than dbverify and rman backup. )
b'coz we have BCV backup already implemented and we
cannot do a dbv every week for 500 gig
)
om Subject: quckways to find block
corruption
Sent
Title: RE: quckways to find block corruption
Also check DBMS_REPAIR.
rgds
amar
http://amzone.netfirms.com
-Original Message-
From: Jack van Zanen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: quckways
If you want to reduce the amount of time to check for block corruptions,
there are several approaches. These can be used individually or combined.
1) Only check the files for system, rollback and data tablespaces. Indexes
can be rebuilt and temp can be ignored.
2) Break up the checking so you do
Srinivas
I think that as a minimum, to detect corruption you must read all data
blocks. There are several methods, most involve an Oracle process that will
error if a corrupt block is encountered. Export to /dev/null was mentioned
already. I have used ANALYZE TABLE VALIDATE STRUCTURE CASCADE,
Agreed . though I have had disappointing results with 'ANALYZE ...
VALIDATE STRUCTURE ...' not detecting corruption only later to have an
application (i.e. user) encounter data block (or index block) corruption. My
last incidence ... I simply did a count(*) .. full table scan ... which
]cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
om Subject: quckways to find
block corruption
Sent by:
[EMAIL PROTECTED]
23-09-2002 12:03
Please
: quckways to find block corruption
Srinivas
I think that as a minimum, to detect corruption you must
read all data
blocks. There are several methods, most involve an Oracle
process that will
error if a corrupt block is encountered. Export to /dev/null
was mentioned
already. I have
Royce,
Just small correction
It is
Analyze table table_name validate structure cascade;
which checks for corruption of table and indexes based on that table and
error is written in alertSID log as well as producing trace file.
In my experience to check table/index level corruption this is
]]
Sent: Monday, September 23, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: quckways to find block corruption
Srinivas
I think that as a minimum, to detect corruption you must
read all data
blocks. There are several methods, most involve an Oracle
process
[EMAIL PROTECTED]
[EMAIL PROTECTED]cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
om Subject: quckways to find
block corruption
Sent by:
[EMAIL PROTECTED
FWIW I like to do full exports in the middle of the night
just for this reason as a hot backup wont cut it.
If you find a corrupt block you can fix it using
either a PL/SQL or PRO*C rountine that can be
found on Metalink.
Search for corrupt blocks.
Mike
-Original Message-
Sent:
Beware, we had a corrupt block in an index. Big deal you say!? Every time
the client used the index
the database would crash! Not good. We now do exports, and dbverify. But
they don't catch bad index
blocks. We also learned to check the alertlog a couple of times a day.
R. Smith
For those of you that are hitting corrupt blocks frequently enough to be
this current on it, I assume you are using the parameters introduced in
8.1.6 to keep on top of this,
db_block_checking
db_block_checksum
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL
Ron,
Are you rebuilding indexes frequently on this system using parallel clause?
With certian version of Oracle (7.3.4.3 on HP) there was a bug resulting in
index corruption when there were a composite index was involved. Work around
either remove parallel clause or upgrade to 7.3.4.5.
yes, but you can recreate an index without losing any data.
fwiw. mike
-Original Message-
Sent: Monday, September 23, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
Beware, we had a corrupt block in an index. Big deal you say!? Every time
the client used the index
the
Sorry for not noticing this email thread earlier, so I apologize for chiming
in late...
---
The original poster (Srinivas) disqualified RMAN as a possibility because he
said that they were already getting backups via BCVs. My question is:
are you splitting off BCVs and then calling it good,
18 matches
Mail list logo