DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Control file currupted

  1. #1
    Join Date
    Sep 2007
    Posts
    47

    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,

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Does all your controlfile reside on the same disks ?

    regards
    Hrishy

  3. #3
    Join Date
    Sep 2007
    Posts
    47

    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,

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    dont you have a good control file left? you were mutiplexing them right?

  5. #5
    Join Date
    Sep 2007
    Posts
    47

    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,

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    i didnt say backups, i mean your multiplexed version on the control file - where is your dba?

  7. #7
    Join Date
    Sep 2007
    Posts
    47

    Control file currupted

    hi, yes they are multiplexed.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    so copy the good one over the top of the bad one

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  10. #10
    Join Date
    Nov 2007
    Location
    Douala, Cameroun.
    Posts
    77
    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
  •  


Click Here to Expand Forum to Full Width