-
how to recover from the loss of control files and redo log files
dear friends
i have a oracle 9i database (release 9.2.0.1.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
startup nomount
create controlfile reuse database "mydata" resetlogs noarchivelog
xxx
xxx
xxx
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.
regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|