Error 3403

Severity

22

Message text

During recovery initialization, page %ld was encountered.  This page belongs to object %ld, not the log.

NoteThis error may be caused by a hardware problem.

Explanation

During recovery, Adaptive Server scans the transaction log until the last page is found. During this scan, if a page is found that has an object ID on the page header that is not the same as that of syslogs, error 3403 occurs.

This may occur either as a result of a hardware failure or due to an Adaptive Server problem.

WARNING! This is a serious error and you must rebuild the affected database either using bcp or from clean backups.

Action

If you have a good backup, restore the database from your backup:

  1. Drop the database. If the drop fails, follow the instructions in “Dropping a database when drop database fails” in the chapter “Other Useful Tasks” in the most recent version of the Troubleshooting and Disaster Recovery guide.

  2. Create a database for load. Make sure the database you create has sizes as least as large as those in sysusages for the original database (and that all other sysusages values match the original values). For more information about creating a database for load, refer to “create database” in the Reference Manual: Commands.

  3. Load the database from backup. (Refer to “load database” in the Reference Manual: Commands.)

  4. Use the online database command to make the database available for use.

To prevent this error from being raised in the future, either perform a normal shutdown of Adaptive Server (specifically, do now use the nowait option), or checkpoint each database that is being used before shutting down Adaptive Server.

Additional information

Refer to “Developing a Backup and Recovery Plan” in the System Administration Guide: Volume 2 for complete information about how to safely create, dump, load, and re-create databases.

Versions in which this error is raised

All versions