Database repair concept - assure_mimix - 6.0

Assure MIMIX for AIX Guide

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software for AIX
Version
6.0
ft:locale
en-US
Product name
Assure MIMIX for AIX
ft:title
Assure MIMIX for AIX Guide
Copyright
2025
First publish date
2003
ft:lastEdition
2025-03-12
ft:lastPublication
2025-03-12T05:07:12.494000

To perform a database repair, you may use the Assure MIMIX for AIX's “virtual restore” operation, recovering a snapshot image of the database to some point in the past on the writable snapshot, and then a “pick and pull” operation to extract pieces of data from that snapshot for reinsertion into the production database.

In this repair scenario, only some pieces of data are corrupted but the production database is still running. After you restore a historical, non-burning image of the database on the snapshot, you can pull pieces out of it and put them back into the live production database to repair the bad pieces of data. You can put out the fire with information. Assure MIMIX for AIX restores automatically on the back-end snapshot.

Using the Assure MIMIX for AIX snapshot to visualize complete historical images of the database enables DBAs to forgo spending time on a daily basis saving pieces of database for possible use at a later time. Also, DBAs have access to the exact historical image they want (typically by reviewing logs, etc.).