Results 1 to 3 of 3

Thread: DB corrupted

  1. #1
    Join Date
    Jun 2008

    Unanswered: DB corrupted


    I am using Oracle 9i for my application, which is based on Client - Server. My server is installed as NT service on Windows. Now when my server is running i.e. writing information in DB, and I do restarts of NT service, some tables of DB is getting corrupted. The same thing happens even if I restart my whole machine.

    Is it normal in DBs and how we can guard ourself from this, I mean, should thru DB level or application level.

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    I do restarts of NT service
    Are you shutting down the database prior to stopping the service?

    The same thing happens even if I restart my whole machine
    How are you restarting your whole machine?

    how we can guard ourself from this
    Stop doing it!

    I have never had a problem before, but if you switch off the server or stop the service whilst the database is still open then I'm not really surprised that things aren't working well. Shutdown the database gracefully, then restart the service, then see if it's working OK.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >some tables of DB is getting corrupted.
    Using SQL*Plus along with CUT & PASTE, please provide proof of this.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts