- Improper data feeds
- User errors
- Deliberate data corruption
- Application software errors
- Fallback from application change migrations.
Some of these outage possibilities aren’t protected in a hardware replication environment. For instance, if a user inadvertently corrupts some data or applies bad system maintenance, a remote replication environment would also be impacted. A restore from a point-in-time backup might entail too much data loss. Remote replication is a highly effective solution for a site-wide disaster, but those are rare events. It’s more likely that a user will experience damage in a database that requires additional functionality than is provided by a hardware backup or replication process.
To completely protect the database environment, a customer needs a variety of tools to support database copy, log processing, and recovery management activities. These tools can reduce or eliminate the downtime for both planned and unplanned events. Using the right recovery software tools, the customer can:
- Produce a consistent database image copy with minimal outage
- Extract the effects of a bad update transaction with no outage
- Recover a complex application with innovative log processing
- Manage the log environment and prepare for optimum recovery, including dropped DB2 objects
- Define application recovery groups and simulate or estimate recovery - Leverage any investment in intelligent storage for backup and recovery
- Prepare for automated database recovery, with coordination between DBMS applications (to any point-in-time for both local and disaster recovery events)
- Leverage the recovery tools in daily operations (e.g., data migration, log reporting, and reduced resource consumption).
The proper database recovery tool kit will protect the application database for both local and disaster recovery, allowing for recoverability while ensuring the highest level of availability. Using hardware and software recovery tools isn’t mutually exclusive; many companies employ both technologies.
For instance, some software backup tools can exploit the investment in hardware replication technology by automating the process or providing reports. Some companies replicate a few applications and use normal software recovery tools for the rest. The acquisition of such tools can be cost-justified based on their impact on reducing or eliminating downtime and their ability to improve resource consumption for daily operations.
In today’s high-availability, complex e-business world, it’s imperative to protect the corporate data asset. If the database is unavailable, the millions of dollars invested in IT aren’t returning a benefit to the business, and IT becomes a cost burden. Software-based recovery tools aren’t a luxury or an insurance policy; they’re a key component of strategic application database availability and support.