你在这里

Unable to open Oracle Database

Posted by PDSERVICE on 10月 23, 2018 In

Yesterday my system crashed and when it opened database couldn't be opened.

It gives below error. system is running is on no achieve log mode. I tried to open using reset log but failed.

alter database open resetlogs;

error at line 1:

ora-01194: file 1 needs more recovery to be consistent

ora-01110: data file 1

Oracle database version - 11g

is there any way to open database without archive log files? Please help as it is production database.

My database is on Windows 7. Will PRM software can be installed on windows? and can it help to recover my database?

Of course it can

I could able to operate DUl but during unload data no data is getting unloaded. Below is the error-

Pls show me the prm.log