Recovering from Database Problems

Tools such as BMC PATROL can detect failures of key database processes and restart them automatically. MC/ServiceGuard provides a similar capability, and is also able to restart an application on another system.

Assuming successful backups exist, databases such as Oracle can recover from a disk failure without losing data. This requires a trained database administrator, because the process typically is not automated. The Oracle Recovery Manager product can be used to manage the backup, restore, and recovery processes.

After a system failure, Oracle can automatically recover data to a consistent state by performing full recovery. This is done by ensuring that committed changes are applied to the database and that ...

Get UNIX® Fault Management: A Guide for System Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.