Data Protection Strategy
So far, this chapter has described the facilities that are available for a 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 planning and practice. When you have planned a data protection strategy, you should put it into practice by simulating a disk crash and restoring the databanks according to your 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 and SQLDB) and then restore or recreate them.
Once you have a successful strategy, build command files (scripts) that perform the correct operations regularly.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40