Oracle Corrupted Datafiles

Posted by PDSERVICE on Oct 23, 2018 In

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 tablespace

i downloaded DUL but when i issue scan to system datafile it give an error:

DB data file'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 data files 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 .

You are here