From: "Sweetser, Joe" <JSweetser@icat.com>
To: "Laimutis.Nedzinskas@seb.lt" <Laimutis.Nedzinskas@seb.lt>, 'oracle-l'
 <oracle-l@freelists.org>
Subject: RE: English semantics help needed
Thread-Topic: English semantics help needed
Date: Tue, 29 Nov 2011 14:29:05 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C578AB736@ICATEXCH2.ICAT.com>
References: <8d55971f9bdc472137d8810d7c0e9075.squirrel@society.servebeer.com>
 <D0A0129F-15B3-4623-8552-33585B547951@phillip.im>
 <CAJ2-Qb9zMXkX6EWXqBJOoHtxowOsEVdC1=5z51ns0MJ6_ZCfVw@mail.gmail.com>
 <4ED3DEA2.3050604@interia.pl>
 <CAPCNhx3ck5P6V4g8Ctve7d0qoePKSPZ71e7j7bPH5k0tdWr4-g@mail.gmail.com>
 <OF4A3CBE2E.031DAC8B-ONC2257957.003C3E9A-C2257957.003C9F88@seb.lt>
 <CAELkjfXpMpLMTeEM+rh4GnejpzauzvF+5=wKNMLt2ZUdhE485A@mail.gmail.com>
 <OFEF2FDFDD.A265B7D9-ONC2257957.004296A8-C2257957
 <OFF722FAF4.F1D5BB07-ONC2257957.004B2420-C2257957.004BAB13@seb.lt>
In-Reply-To: <OFF722FAF4.F1D5BB07-ONC2257957.004B2420-C2257957.004BAB13@seb.lt>
Accept-Language: en-US
Content-Language: en-US
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: JSweetser@icat.com

I read it the opposite way and believe the patch does, indeed, fix the root cause. But, as Saurabh Manroy already said, the patch does not fix any data that has already been corrupted.

From the note:
Patches
In order to prevent this issue install Patch 7662491

-joe

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Laimutis.Nedzinskas@seb.lt
Sent: Tuesday, November 29, 2011 6:46 AM
To: 'oracle-l'
Subject: RE: English semantics help needed

Judging from the note, the fix solves redo issue only.
But it talks about block corruption too.
We had a similar corruption of heavily accessed table block, SR is opened.

My understanding is that the fix does not fix the root cause of corruption.
The bug is still there.


---------------------------------------------------------------------------------

Please consider the environment before printing this e-mail


  From:       "Mark W. Farnham" <mwf@rsiz.com>

  To:         <Laimutis.Nedzinskas@seb.lt>, "'oracle-l'" <oracle-l@freelists.org>

  Date:       2011.11.29 15:35

  Subject:    RE: English semantics help needed


I don't have time to read the note right now, I hope this is on target:

There have been bugs in the past that only affected the redo logs. Is the
current bug under discussion one of them?

If so, your primary database is okay, but if you have physical replication
target databases may have files that need to be reinstantiated or have
blocks repaired.

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]
On Behalf Of Laimutis.Nedzinskas@seb.lt
Sent: Tuesday, November 29, 2011 7:09 AM
To: oracle-l
Subject: Re: English semantics help needed

>Patch would fix the rootcause but that would be of help only in future.

will it ? They talk about redo/archive logs but not about data blocks.


----------------------------------------------------------------------------

-----

Please consider the environment before printing this e-mail


  From:       saurabh manroy <saurabhmanroy@gmail.com>


  To:         Laimutis.Nedzinskas@seb.lt, oracle-l <oracle-l@freelists.org>


  Date:       2011.11.29 13:22


  Subject:    Re: English semantics help needed


>> the patch does not fix the corruption. It only makes sure the
redo/archive logs are cleaned from this corruption so that backups/standby
work.


No,
From the note 7662491.8:
"The fix prevents this corruption to be introduced in the redo and will not
fix any existent corruption that is already introduced in the redo/archived
logs. Meaning that if the patch is installed and a recovery is attempted
again using the same archived logs, the error will be still produced."


>> select from table would still give an error, wouldn't it ?


Yes,Patch wouldn't fix anything that is already corrupt. Note suggests to
use dbms_repair to skip corrupt blocks.
>> There is no fix for the root cause ?
Patch would fix the rootcause but that would be of help only in future.


Regards,
Saurabh Manroy


On Tue, Nov 29, 2011 at 12:02 PM, <Laimutis.Nedzinskas@seb.lt> wrote:.
      Bug 7662491 - Array Update can corrupt a row. ORA-600
      [kghstack_free1]
      ORA-600 [kddummy_blkchk][6110/6129] [ID 861965.1]

      Hi listers

      I have problem reading the metalink Bug 7662491 and especially patch
      7662491. Btw, we had a similar issue meaning this is not a
      theoretical
      interest of mine.

      Do I interpret the note correctly:

      the patch does not fix the corruption. It only makes sure the
      redo/archive
      logs are cleaned from this corruption so that backups/standby work.
      select from table would still give an error, wouldn't it ?
      There is no fix for the root cause ?


      Brgds, Laimis N


----------------------------------------------------------------------------

-----


      Please consider the environment before printing this e-mail

      --
      http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--
http://www.freelists.org/webpage/oracle-l