Testing Your Data Protection
So far, this chapter has described the facilities that are available for the system manager to maintain the system. But how do you know that you are using the functionality in the right way, and that you will be able to get the system running again if something happens?
The answer is practice. When you have decided on a certain strategy, a disk crash should be simulated and the databanks restored following the chosen strategy.
Check that the contents of all tables are the same as before the simulated crash. Do not forget to simulate a crash of the system databanks (SYSDB, TRANSDB, LOGDB, SQLDB) and then restore or recreate them.
When you have decided on a successful strategy, then build command files (scripts) that take "normal" backups, backups on the fly, and create shadows.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40