Unable to open database - needs media recovery

Last week we had disk failure. Unfortunetly I have lost arch logs and trc files. When we were trying to start the database, we starting getting the following error:

ORA-01113 file 8 needs media recovery.

After reading arround we tried the followings:

Startup nomount;
recover database until cancel;
[cancel]
alter database open resetlogs;

When we tried again, we started getting new error:

ORA-01194: file 1 needs more recovery to be consistent;

It is complaining onSYSTEM01.DBF file now. Please guide me how can open the database without latest logs and Tracefiles;

Thanks in Advance.

V.

how about just RECOVER DATABASE?

Quote:

---

Originally Posted by marist89

how about just RECOVER DATABASE?

---

I have tried that same problem. Thanks

Basically that error is telling you that all your files are not at a consistent point. Your system.dbf file needs to have more recovery applied (from redo or archived redo) in order to be consistent enough to open.

What do you have for a backup?

Unfortuntely, we don't backup this server. It is one of our test server.

one hidden parameter can help this, remember do a backup once open. either full export/import.

_ALLOW_RESETLOGS_CORRUPTION=TRUE

DO IT ONLY YOU HAVE NO OTHER WAY TO RECOVER YOUR DATA.

Pls be sure that it's not supported by Oracle and it may bring ur database to dangerous situation.

I have move a step further after finding some files from last months folder command. It don't have all the files but SYSTEM,CONTROL and REDOs.

Now I am getting this error:

ORA-0283: recovery session cancelled due to errors
ORA-01112: database file 3 failed verification check
ORA-01110: data file 3: g:\oradata\DWTEST\RBS01.dbf'
ORA-01207: file is more recent then controlfile - old control file.

Any ideas to move forward from here.

Do you think, if try to take this rollback segment offline. will that going to work. Please advice.

Quote:

---

Originally Posted by avion1

Do you think, if try to take this rollback segment offline. will that going to work. Please advice.

---

no.

If it's a test database then just clone your production db, re-apply any changes and you're done.

Thanks for the advice.

But, I am trying to open database withot restoring from live. We are not bothered about loosing data. Cheers.

Quote:

---

Originally Posted by avion1

Thanks for the advice.
We are not bothered about loosing data. Cheers.

---

Then why not just create another database?

Quote:

---

Originally Posted by avion1

Thanks for the advice.

But, I am trying to open database withot restoring from live. We are not bothered about loosing data. Cheers.

---

I have a feeling that you need to practice your database recovery skills. :rolleyes:
As pennance I want you to restore this database from prod 5 times. ;)