你在这里

You are here:

urgent, oracle system file (system01.dbf) error, how to fix it and exp data?

Posted by PDSERVICE on 4月 27, 2017 In

our db is running without backup, and today our db was broken by disk error, after fixed disk issue, I try to start db and then exp data and create a new db.

after recover database until cancel and startup db with _allow_resetlogs_corruption=true ,now db can be opened, but can not do shutdown with error ora-600 [4193], [31358], [31362], [], [], [], [], [] and ORA-00604,ORA-01578 Oracle data block corrupted(file 1,block#60322),ORA-01110: datafile 1: d:\oradata\system01.dbf . and now I can not create any object, it was failed with error ora-600 [kcbgcur_9].

pls help me, how to fix this issue and export my data?my db version is 10.2.0.1 and os is win2003 sp2. thanks a lot.

now I can not shutdown db, I can stop oracle db service and start it in windown services tool.

Answer:

TRY PRM-DUL here:

http://zcdn.parnassusdata.com/DUL5108.zip

PRM can work on damaged file systems, ASM DiskGroup and data files. Even if Oracle data dictionary lost, PRM can also scan and recover dictionary based on inconsistent SYSTEM.DBF tablespace backup. PRM can support most of Oracle database functionalities for example, Cluster, LOB, and partition.