Help to recover the corrupted database without backup... The following info displayed when the database service tried to start:

I. 07/09 10:14:41. Checkpoint log... E. 07/09 10:14:41. ERROR Assertion failed: 201501 (12.0.1.3840)[emr] Page 0x0:0x2d880 for requested record not a table page E. 07/09 10:15:58. Internal database error ERROR Assertion failed: 201501 (12.0.1.3840)[emr] Page 0x0:0x2d880 for requested record not a table page -- transaction rolled back I. 07/09 10:16:03. Database server shutdown due to startup error

Does SAP SQL Anywhere have tool to extract data?

asked 22 Jul '14, 13:18

pLee's gravatar image

pLee
21691119
accept rate: 0%


This type of database corruption is the result of a problem encountered when the database server attempts to search the linked list of the database for the specific table or record and the table or record is not present on the page found in the linked list. This can also indicate a problem with the database linked list, or pages missing from the database linked list.

The ideal situation for recovery from any type of database corruption is to use a tested backup and recovery strategy. A tested backup and recovery strategy ensures that there is no loss of data from database corruption.

If there is no tested backup and recovery strategy, or if it is discovered that the backups are corrupt, there is a method that may allow you to salvage data from the corrupt pages. Depending on the number of pages corrupted, this type of corruption can be isolated to a single table, or spread over spanning multiple tables. With data salvage, there is never a guarantee as to the amount of data that can be salvaged or the integrity of the data that is salvaged.

Unload utility provides the ability to automatically rebuild a database using either the -ar, -an, or -ac options.

If the above procedure does not work to resolve the database assertion error, then it is recommended connect with Technical Support team.

Read this article for more details: Salvaging Data When There are Corrupt Pages in the Database

You can also try 3rd party repairing software like SQL Anywhere repair software from Stellar Phoenix

permanent link

answered 23 Jul '14, 02:53

Carder_Jim's gravatar image

Carder_Jim
312
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×22

question asked: 22 Jul '14, 13:18

question was seen: 1,443 times

last updated: 10 Sep '14, 08:25