Shulou(Shulou.com)06/01 Report--

Sybase database features:

1. Database based on client / server architecture

2. Truly open database

3. A high-performance database

Difficulties in troubleshooting Sybase database:

The application of Sybase database and its own architecture are relatively complex, and most technicians and companies do not fully understand the underlying structure and operating mechanism of Sybase database, which poses a great obstacle to the data recovery and repair of Sybase database. So what should we do when there is a serious failure in the Sybase database?

Any system and application should abide by the computing and storage rules of the computer, but some concepts and rules are too crude, so that we need more time and energy to learn and be familiar with. This is also the current situation of data recovery and data repair in Sybase database.

The following will take a real case as an example to show you how to solve the problem that the database cannot be started:

Device Information:

1. Sybase version: SQL Anywhere 8.0

2. Failure phenomenon: the database cannot be started.

3. The error message is shown in the figure:

Then the error is reported after using Sybase Central connection, and the conclusion is that the database can not write back the normal data due to the sudden power outage, resulting in inconsistent data of multiple storage pages, inconsistent system table description and storage table, and the underlying data of some storage pages are completely cluttered.

So we correct the cluttered and erroneous storage pages at the bottom of the Sybase database, and change some of the information in the system tables.

After the completion of the heavy Sybase database repair work, the Sybase database has been successfully started and connected successfully using Sybase Central. It has been verified by the user that there is no problem. At this point, the data recovery work is over.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.