Assertion Faileure 201503

[chris_keating]

Hi,

We have a database that is failing to start with Assertion Failed: 201503.
Record 0x1 not present on page.

We are unable to unload the database excluding any corrupted table as the database will not even initialise.

Unfortunately despite running validation checks each evening the corruption has only revealed itself on startup therefore previous backup now also fail to start.

Do you know if there any tools that would allow us to rebuild this database?

Thanks in advance

Damian

[chris_keating]

Please provide the full Assertion message specifically the value that follows "on page". This will contain info about the page type.

[iamdna]

Record 0x1 not present on page 0x0:0x50475

[johnsmirnios]

If you can get the database started (see my comment about -f and renaming the .log file), try an unordered unload (dbunload -u) which will prevent the usages of key indexes. Failing that, we have been able to recover some databases if you send it to support.

[iamdna]

There are no recent backups and we are looking to see if we have any older backups that are archived that don't have the corruption.
We have tried the -f but the issue still persists unfortunately.