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@xxxxxxxxx> 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 > -- //www.freelists.org/webpage/oracle-l