how to recover from the loss of control files and redo log files
i have a oracle 9i database (release 220.127.116.11.0),database running in noarchive log mode and i don't have multiplexed control files either redo log files.few days back i lost all my control files and all redo log files because my got down due to power failure.i have tried something but i can't got it right.database still not opened.i can manage marginal data loss.
Steps which i had tried
create controlfile reuse database "mydata" resetlogs noarchivelog
control file created.
Then i tried to open the database with
alter database open resetlogs;
but it give me error that your '/ora9idb/odb/dbs/system01.dbf' file needed recovery
apply the file.
I did not lost any of my datafiles.
So please tell me how can i overcome the problem.
Click Here to Expand Forum to Full Width