问题描述：

alter pluggable database pdb$seed open
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 5, block # 24318)
ORA-01110: data file 5: '/u01/app/oracle/oradata/PRODCDB/pdbseed/system01.dbf'

问题分析：

SYS@PRODCDB> select owner,segment_name,segment_type from dba_extents where file_id=5 and 24318 between block_id and block_id+blocks-1;

no rows selected
[oracle@ocm01 admin]$ oerr ORA 01578
01578, 00000, “ORACLE data block corrupted (file # %s, block # %s)”
// *Cause: The data block indicated was corrupt. This was a physical
// corruption, also called a media corruption. The cause is unknown
// but is most likely external to the database. If ORA-26040 is also
// signaled, the corruption is due to NOLOGGING or UNRECOVERABLE
// operations.
// *Action: The general method to repair a media corrupt block is to restore
// a backup and recover the backup. For databases in ARCHIVELOG
// mode, use block media recovery or media recovery. In some situations,
// you can also drop the segment and re-create it. For example, you can
// drop an index and re-create the index.
Corrupt block relative dba: 0x00407820 (file 1, block 30752)
Completely zero block found during dbv:

Page 30753 is marked corrupt
Corrupt block relative dba: 0x00407821 (file 1, block 30753)
Completely zero block found during dbv:

Page 30754 is marked corrupt
Corrupt block relative dba: 0x00407822 (file 1, block 30754)
Completely zero block found during dbv:

Page 30755 is marked corrupt
Corrupt block relative dba: 0x00407823 (file 1, block 30755)
Completely zero block found during dbv:

Page 30756 is marked corrupt
Corrupt block relative dba: 0x00407824 (file 1, block 30756)
Completely zero block found during dbv:

Page 30757 is marked corrupt
Corrupt block relative dba: 0x00407825 (file 1, block 30757)
Completely zero block found during dbv:

Page 30758 is marked corrupt
Corrupt block relative dba: 0x00407826 (file 1, block 30758)
Completely zero block found during dbv:

Page 30759 is marked corrupt
Corrupt block relative dba: 0x00407827 (file 1, block 30759)
Completely zero block found during dbv:

Page 30760 is marked corrupt
Corrupt block relative dba: 0x00407828 (file 1, block 30760)
Completely zero block found during dbv:

Page 30761 is marked corrupt
Corrupt block relative dba: 0x00407829 (file 1, block 30761)
Completely zero block found during dbv:

Page 30762 is marked corrupt
Corrupt block relative dba: 0x0040782a (file 1, block 30762)
Completely zero block found during dbv:

Page 30763 is marked corrupt
Corrupt block relative dba: 0x0040782b (file 1, block 30763)
Completely zero block found during dbv:

Page 30764 is marked corrupt
Corrupt block relative dba: 0x0040782c (file 1, block 30764)
Completely zero block found during dbv:

Page 30765 is marked corrupt
Corrupt block relative dba: 0x0040782d (file 1, block 30765)
Completely zero block found during dbv:

Page 30766 is marked corrupt
Corrupt block relative dba: 0x0040782e (file 1, block 30766)
Completely zero block found during dbv:

Page 30767 is marked corrupt
Corrupt block relative dba: 0x0040782f (file 1, block 30767)
Completely zero block found during dbv:

DBVERIFY - Verification complete

Total Pages Examined : 32000
Total Pages Processed (Data) : 14006
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 8380
Total Pages Failing (Index): 0
Total Pages Processed (Other): 2638
Total Pages Processed (Seg) : 1
Total Pages Failing (Seg) : 0
Total Pages Empty : 6464
Total Pages Marked Corrupt : 512
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 1739896 (0.1739896)

说明：未归档模式，无rman备份和冷备