-
Control file currupted
hi, the database controlfile got currupted due to power fluctuation. when I give startup command, it is not identifying control file and unable to startup the database.
The database is oracle 8i on windows XP. There is no backup of the database and the database is in no archivelog mode.
Immediate help is highly appreciated.
thanks,
-
Hi
Does all your controlfile reside on the same disks ?
regards
Hrishy
-
Control file currupted
hi, the control files resides on multiple disks.
And Iam having one more doubt, do i need to give the location of all the datafiles in create control file command or just I have to give only system tablespace datafile path.
thanks,
-
dont you have a good control file left? you were mutiplexing them right?
-
Control file currupted
hi, i don't have any backups for datafiles, control files and log files. Do I need to manually create the control file.
thanks,
-
i didnt say backups, i mean your multiplexed version on the control file - where is your dba?
-
Control file currupted
hi, yes they are multiplexed.
-
so copy the good one over the top of the bad one
-
devey.. looks like ur talkting to a developer.. lol
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Hi,
How did it go Rehan? What Dave told u should normally work. I had the same problem once and I did what he told you and my database started.
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
|