Re: DBMS_REPAIR.CHECK_OBJECT
From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Sun, 25 Apr 2010 08:55:13 -0700 (PDT)
Message-ID: <e25aed36-fa0c-4a75-bcf0-92f611493ba5_at_z11g2000yqz.googlegroups.com>
On Apr 25, 5:40 am, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:
> Never used DBMS_REPAIR so can't help you with it. However it may be
> more important to determine what caused this issue and how to prevent
> it from happening again, especially in Prod environment. Did you get
> any ORA-00600, ORA-07445 error? Was there are hardware issue? I/O
> errors? Check UNIX log. What happens if you try to run dbv utility for
> this file? Or copy it to /dev/null using 'cp' command?
Date: Sun, 25 Apr 2010 08:55:13 -0700 (PDT)
Message-ID: <e25aed36-fa0c-4a75-bcf0-92f611493ba5_at_z11g2000yqz.googlegroups.com>
On Apr 25, 5:40 am, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:
> Never used DBMS_REPAIR so can't help you with it. However it may be
> more important to determine what caused this issue and how to prevent
> it from happening again, especially in Prod environment. Did you get
> any ORA-00600, ORA-07445 error? Was there are hardware issue? I/O
> errors? Check UNIX log. What happens if you try to run dbv utility for
> this file? Or copy it to /dev/null using 'cp' command?
No clue what cused it, may be Oracle 11g is not stable Never happend to me in previous version databases. Received on Sun Apr 25 2010 - 10:55:13 CDT