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].
Please 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
https://s.dbrecover.com/dbrecover-for-oracle-latest-dist.zip
PRM can work on damaged file systems, ASM DiskGroup and datafiles. 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.
DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.