Database Recovery
Database recovery is the set of processes and tools used to restore a database to a usable, consistent state after data loss, corruption, or an outage. The goal is to minimize downtime and data loss while preserving integrity and compliance. This subject area enables tracking Database Recovery, change rate, lifecycle state, database size, protected database count, and related details.
Business Questions
The subject area can answer the following business questions:
- What is the change rate?
- What is the compression ratio?
- What is the recovery database count?
- What is the database size?
- How has the number of recovery databases changed over time (daily, weekly, monthly)?
- How has the database size changed over time (daily, weekly, monthly)?
Logical Model
The Database Recovery subject area is based on a relationship-driven logical model.
This diagram shows how the Database Recovery fact table is related to its dimension tables:
Metric Details
The fact folders in this subject area include the following metrics:
| Metric | Definition |
|---|---|
| Change Rate | Provides the percentage of data change between successive incremental backups |
| Compression Ratio | Provides the compression ratio for protected database backups |
| Database Recovery Protected Database Count | COUNT(ocira_fact_key) from the fact view's ocira_fact_key (maps to ocira$fact_key) |
| Database Size in GBs | Provides the current logical database size in GBs |