Kbase P5285: How to make sure you have a valid online database backup
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to ensure that an online backup can be restored
GOAL:
How to make sure you have a valid online database backup
FIX:
The only way to ensure that an online database backup is valid is to restore it and to have performed successfully crash recovery.
An online backup made with Progress utility "probkup" contains, at its beginning, a copy of the Before Image (or Primary Recovery Area). This copy of the Before Image is made while the database is put in a "quiet" state, i.e. while no transaction can cause writes to the bi file.
When you restore an online backup all the transactions active at the start of the backup will be rolled back when the database is restarted and it goes through crash recovery. Running "proutil <dbname> -C truncate bi" is a way to perform crash recovery without starting a database server.
What applies to online backups will also apply to offline backups made with the option "-no recover".