Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Database in inconsistent state.

    the control center shows that the database is in inconsistent state. What does this mean exactly? I've tried to get rid of it by trying the restart database command but the control center still keeps on showing it. The database can be connected to at this time.

    Any advice?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    This means that there are Units of Work active against the database. If you disconnect all connections, you should see that the state changes to consistent.



  3. #3
    Join Date
    Mar 2004
    You can ignore that message in most cases. Essentially it indicates one or more of the following conditions -
    - an active transaction going on
    - changes that took place in the database which have not been committed completely (active transaction!)
    - changes that took place in the database which have been committed, but not flushed to the tablespace (i.e. flushed to logs only)

Posting Permissions

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