FAQ
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 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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 2, '12 at 11:43a
activeMay 2, '12 at 11:43a
posts1
users1
websiteoracle.com

1 user in discussion

Shastry(DBA): 1 post

People

Translate

site design / logo © 2022 Grokbase