RE: quckways to find block corruption

2002-09-24 Thread Mohammad Rafiq
] [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

quckways to find block corruption

2002-09-23 Thread kommareddy sreenivasa
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

Re: quckways to find block corruption

2002-09-23 Thread Jack van Zanen
) om Subject: quckways to find block corruption Sent

RE: quckways to find block corruption

2002-09-23 Thread Amar Kumar Padhi
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

RE: quckways to find block corruption

2002-09-23 Thread Fink, Dan
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

RE: quckways to find block corruption

2002-09-23 Thread DENNIS WILLIAMS
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,

RE: quckways to find block corruption

2002-09-23 Thread Christopher Royce
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

Re: quckways to find block corruption

2002-09-23 Thread Mohammad Rafiq
]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

RE: quckways to find block corruption

2002-09-23 Thread Jesse, Rich
: 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

RE: quckways to find block corruption

2002-09-23 Thread Mohammad Rafiq
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

RE: quckways to find block corruption

2002-09-23 Thread Fink, Dan
]] 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

RE: quckways to find block corruption

2002-09-23 Thread DENNIS WILLIAMS
[EMAIL PROTECTED] [EMAIL PROTECTED]cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) om Subject: quckways to find block corruption Sent by: [EMAIL PROTECTED

RE: quckways to find block corruption

2002-09-23 Thread Johnson, Michael
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:

RE: quckways to find block corruption

2002-09-23 Thread Smith, Ron L.
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

RE: quckways to find block corruption

2002-09-23 Thread DENNIS WILLIAMS
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

RE: quckways to find block corruption

2002-09-23 Thread Mohammad Rafiq
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.

RE: quckways to find block corruption

2002-09-23 Thread Johnson, Michael
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

Re: quckways to find block corruption

2002-09-23 Thread Tim Gorman
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,