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

    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?
    Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    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.

    HTH

    Andy

  3. #3
    Join Date
    Mar 2004
    Posts
    46
    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
  •