Re: Block corruption post upgrade and analyzed the DB objects

From: Shastry(DBA) <"Shastry>
Date: Wed, 2 May 2012 17:12:25 +0530
Message-ID: <CAFQkUXQpy3fg+prCh4GAmdU=FRAcucF8PQn=nF+=MUkYO=JEVw_at_mail.gmail.com>



You can refer the below metalink note:
ORA-1578 / ORA-26040 Corrupt blocks by NOLOGGING - Error explanation and solution (Doc ID 794505.1)

Thnx
A

On Wed, May 2, 2012 at 12:53 AM, Apps DBA <dbaorapps_at_gmail.com> wrote:

> Hi All,
>
> I did an upgrade from 11.2.0.2 to 11.2.0.3 (Linux 64 bit) and it went fine
> without any issue. I ran analyze across the DB and found block corruptions
> in analyze log and alert logs as below. Please provide your inputs and
> suggestions on the same.
>
> DBD::Oracle::st execute failed: ORA-01578: ORACLE data block corrupted
> (file # 399, block # 687621)
> ORA-01110: data file 399: '/dev/mapper/oraJSGSTG_data_090_8600Mp2'
> ORA-26040: Data block was loaded using the NOLOGGING option
> ORA-06512: at "SYS.DBMS_STATS", line 23829
> ORA-06512: at "SYS.DBMS_STATS", line 23880
> ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) [for Statement "begin
> DBMS_STATS.GATHER_TABLE_STATS (ownname => 'JSTAPPS
> ', tabname => '"FORECAST_F_D_1432"', estimate_percent => NULL,
> block_sample => TRUE, degree => 30, method_opt => 'FOR ALL
> L COLUMNS SIZE 1', granularity => 'ALL', cascade => TRUE); end; "] at
> /usr/script/oracle/analyze.pl line 277.
> Execute failed for begin DBMS_STATS.GATHER_TABLE_STATS (ownname =>
> 'JSTAPPS', tabname => '"FORECAST_F_D_1432"', estimate__
> percent => NULL, block_sample => TRUE, degree => 30, method_opt => 'FOR
> ALL COLUMNS SIZE 1', granularity => 'ALL', cascaa
> de => TRUE); end; . ORA-01578: ORACLE data block corrupted (file # 399,
> block # 687621)
> ORA-01110: data file 399: '/dev/mapper/oraJSGSTG_data_090_8600Mp2'
> ORA-26040: Data block was loaded using the NOLOGGING option
> ORA-06512: at "SYS.DBMS_STATS", line 23829
> ORA-06512: at "SYS.DBMS_STATS", line 23880
> ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) at /usr/script/oracle/
> analyze.pl line 277.
>
> Thanks,
> Raghu
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 02 2012 - 06:42:25 CDT

Original text of this message