Disaster Recovery Toolset
Overview
ProActive DBA Disaster Recovery Toolset provides provides analysis, recovery and repair of corrupt SAP Sybase ASE databases, including tools that let knowledgeable users perform on-line repair of corrupt tables.
Major benefits include:
- Improved consistency checking finds problems DBCCs can’t
- Check database consistency in the background, while the database remains on-line
- Investigate and repair corruption at the page level using graphical tools
Features
Disaster Recovery Toolset offers a variety of tools for diagnosing, recovering and repairing corrupt data in your databases.
Corruption Diagnostics
Disaster Recovery Toolset lets you schedule regular consistency checks to run in the background using our Task Scheduler. The consistency check logs a record of any problems found.
If problems are found, you can investigate them using our Page Chain Consistency Checker. This powerful tool goes beyond DBCCs to identify problems such as missing (unlinked) page chains or page chain fragments in your database. Since our verification does not depend on DBCCs, it can work around forms of corruption that stop DBCC in its tracks.
Our Consistency Checker produces a concise, easy-to-understand report detailing exactly where the problem(s) are; and, unlike DBCC, there are no “informational” messages to sift through — if something appears in the report, it’s a problem you need to know about!
You can also use our Database Page Map to examine corruption while the database remains on-line. Powerful graphical tools let you walk page chains, index levels, view allocation maps, OAM and GAM pages, and more.
Data Recovery
Often, when data corruption occurs, the database server may not be able to access part or all of the corrupt tables; or it may produce a stack trace in the server’s error log when users try to access the corrupt areas.
Additionally, the error log messages may not indicate the true location of the corruption.
The Disaster Recovery Toolset solves these problems by bypassing the server entirely and reading directly from the database devices or files, so it can find missing data even when the server itself cannot.
Flexible “search-and-rescue” export tools let you build an ISQL script consisting of one INSERT statement for every row in a corrupt table (even including pages inaccessible to the database server), so you can re-import the rows later if necessary. Or, you can save the raw data pages, for repair or reloading.
Data Repair
If you’re faced with data corruption in a live production environment, minimizing downtime is of paramount importance. The Disaster Recovery Toolset meets this need head-on by providing on-line diagnosis and repair of database pages.
Using the convenient GUI window in our Database Page Editor, you can edit and repair damaged pages on-line, so you minimize downtime and loss of data!
Obviously, this is a powerful capability, so a security key is required in order to access the page modification functions. The software takes every precaution to ensure that corruption will be repaired properly, and a backup of every changed page is saved locally, so you can revert the page’s original contents if necessary.
Technology
Disaster Recovery Toolset performs all its verification through a lightweight server-side Agent, rather than going through the database server itself. Thus it incurs no locks on any database objects, and requires no downtime to the database, tables or other objects.
Database Support
Disaster Recovery Toolset supports SAP Sybase ASE versions 11.0 through 16.0.