Verify SAP IQ Database Consistency for Disaster Recovery
You have regular backups, and a disaster recovery plan. But would it execute smoothly if worst came to worst?
Here’s one way you might check database consistency on your disaster recovery system.
Incremental Backup Flavors
Many SAP IQ administrators make incremental backups between full backups. You are probably familiar with the two kinds of incremental backups.
|All blocks changed since the last backup of any kind (FULL or INCREMENTAL)||All blocks changed since the last FULL backup|
|Smaller and faster to back up, but slower to restore||Slower to back up, but faster to restore, because you only restore the last full backup and then the last incremental archive.|
Restoring on a Production System
For complete details, see the SAP IQ Reference: Statements and Options. Basically, you must restore first the full backup, then the subsquent incremental backups.
To fully restore the system, you must restore all incremental backups in the right sequence. This means that, on a production system, you should never start SAP IQ, or your database, between incremental backups.
Restoring on a Disaster Recovery System
On a non-production system, such as your disaster recovery system, however, you might want to start a database between incremental restore operations to verify that the database is consistent.
What could go wrong?
Unfortunately, if you start a database between incremental restores, startup fails with the message “Unable to use transaction log.”
The good news is, there’s an easy fix. To solve this problem, just remove the transaction log.
Checking Database Consistency
To review, here’s the sequence of steps to check, for example, database consistency between virtual decoupled backups.
- Make a full virtual decoupled backup of the production system.
- Take an INCREMENTAL_SINCE_FULL backup of the production system.
- Copy all files to the disaster recovery system.
- Restore virtual decoupled FULL backup.
- Restore virtual INCREMENTAL_SINCE_FULL backup.
- Start database with -iqro 1 (read only), fully verify it, and then shut down.
- Take incremental backup of production system.
- Copy all files across to the disaster recovery system.
- Restore incremental backup.
- Start database unsuccessfully and receive “Unable to use transaction log” message.
- Remove the transaction log.
- Start the database. Fully verify it, and then shut it down.
Schedule this procedure regularly to help ensure that your disaster recovery system will be ready if needed.