ORA-01578 data block corrupted file corruption and repair (learn more about Linux)

Well, let's talk about the cause of the crash:

Use Redhat 5.9 Linux as database server, Friday database is in use, hard shutdown causes database file partial corruption (in Monday, the application does not start up, when viewing the log file, a data table mapping failed)

Query tables are found to be normal when querying data files using PL/SQL, but can cause crashes when using the where restriction condition

(Just to illustrate the command, not to keep the warning at that time)

Then the ORA-01578 data block corrupted appears,

So the problem is that there is a problem with the current data table index, so use the backup data to restore the table separately;

IMP user/password @ service name tables= (Comrtu) file=xxx.dmp

Reference Document Http://www.cnblogs.com/killkill/archive/2010/06/24/1764067.html

ORA-01578 data block corrupted file corruption and repair (learn more about Linux)