Question
We have currupted datafiles in Oracle database
I'm able to start database to mount stage
But when issue ALTER DATABASE OPEN it gives below error
ORA-01173: data dictionary indicates missing data file from system tablespaceI downloaded DUL but when I issue scan to system datafile it give an error
DB datafile's version are not unique
So could you please help us?
Answer
Can you upload the prm.log under the software directory?
If you reduce the number of datafiles input in dul, can it work?
Tool is working now
But I do not know the correct choice
Non-dictionary or dictionry
Try dictionary mode first, if your system datafile is damaged too much, then you have to use non-dictionary mode .
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.