Inconsistent Databases and Recovery
An inconsistent database occurs when administrative changes to a database in the transaction log do not agree with information maintained in the database’s configuration file.
The main causes of inconsistent database errors are improper system administration procedures. These include:
• Initializing the transaction log file with the -force_init_log flag of rcpconfig while the log file still contains open transactions
• Moving or altering files or installation variables without using the appropriate utility such as ingbuild or unloaddb
• Improper procedures when recovering Ingres data from operating system backups
Inconsistent database errors can also be caused by hardware problems or software problems. For example, inconsistent database errors can be caused when the transaction log file or the configuration file has been corrupted by a hardware failure. Inconsistent database errors can also be caused by software bugs. In either case, contact technical support.