ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Aug 2005 14:11:17 -0400
I can NOT believe the if I used NOLOGGING to create and INDEX "long ago" *and*
had
many, many subsequent FULL BACKUPS that it could/did effect or error on a
future recovery?
Again, we are getting this error after full db recovery on indexes created
(NOLOGGING), well before the FULL backup and thus no "NOLOGGING" objects in any
of the arch logs applied...what gives?
Chris Marquez
Oracle DBA
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 59, block # 763411)
ORA-01110: data file 59: '/o04/oradata/orcl/e_indx_05.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
....
ORA-1578 is reported when a block is thought to be corrupt on read.
Note that in Oracle8i the ORA-1578 reports the RELATIVE FILE NUMBER
and not the ABSOLUTE FILE NUMBER. The error should be accompanied
by an ORA-1110 error indicating the absolute file number and name.
...
c) (oThis error is normal if accessing a block which has had
a NOLOGGINGr UNRECOVERABLE) operation performed against
it and has since been recovered. In Oracle8i this case also reports:
"ORA-26040: Data block was loaded using the NOLOGGING option"
Other related posts:
