3102 Database state not valid for roll-forward recovery

Product Information > JADE Error Messages and System Messages > 3000 through 3199 - Database Engine Errors > 3102 - Database state not valid for roll-forward recovery

3102 Database state not valid for roll-forward recovery

Cause

This error occurs when the database determines a roll-forward recovery cannot be permitted because the database state is inconsistent with a restored offline backup.

Action

Refer to the JADE messages log file (jommsg.log), where the reason the utility recover request was rejected is logged.

The following message is logged when a roll-forward recovery is attempted with an online backup.

Roll-Forward Recovery Error: cannot process an online backup

In this case, you must use the JADE Database utility Restore command to process an online backup.

The following message is logged when a roll-forward recovery is attempted with a database image that is not in a closed state.

Roll-Forward Recovery Error: database requires Restart Recovery

A backup containing a database image that is not in a closed state can occur if:

You attempt to copy the files when the database is in a crashed and non-recovered state.

The JADE Database utility touchDB command is provided, to open and close the database and ensure it is not in a recovery state. Restart recovery is performed when the database is opened, if required. If the state of the database is unknown when the backup is to be performed, you should execute the touchDB command prior to copying the files.
There are third-party backup tools copying files while the database is open.

The database opens files in exclusive mode to prohibit external access to the files. However, some third-party backup tools utilize privileged operating system functions to access and copy the file data. Database files copied in such a manner form an inconsistent database image and are invalid for any purpose.