|
|
ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 6 Backup and RecoveryBackup and Recovery Procedures for Nonarchive Logging |
|
This section describes the steps you should follow if you will be using nonarchive logging in full production after loading your tables. The following are described separately:
If you are using nonarchive logging, you should make either a full or partial static backup of the DBEnvironment at frequent intervals. The exact frequency depends on how much the database changes between backups. If there is very little change, then the need for backup is not as great. Use the SQLUtil STORE or STORE PARTIAL command to make a backup copy of all or a subset of the database files in a DBEnvironment. The STORE command starts the DBEnvironment for you, thus rolling back any incomplete transactions. Follow these steps to make a backup copy of the DBEnvironment using SQLUtil STORE:
When you use nonarchive logging, you do not back up log files since you can not use nonarchive log files for rollforward recovery.
In nonarchive mode, your log files should be large enough to hold log records for the largest possible transaction as carried out by the maximum number of concurrent users. A formula for calculating the required size is given in the "Physical Design" chapter. If you develop a need for a larger log, you can use the SQLUtil ADDLOG command to provide another file. Then, when a transaction fills up the first file, ALLBASE/SQL will switch to the second one automatically. If the need for more file space is temporary, use the ADDLOG command to add a new file, then use the PURGELOG command to remove it when it is no longer needed. In the event of a soft crash, simply start up the DBEnvironment again using a START DBE statement or a CONNECT (if AutoStart is enabled). Rollback recovery is automatic. If a transaction was not complete at the time of the crash, you must reenter it. In the event of a hard crash (media failure), if you need to restore the entire DBEnvironment from your backup. Here is the procedure to use once the drive is replaced:
In the event of a hard crash of a disk that does not contain either the SYSTEM DBEFileSet and the DBEConFile, or your single log file used for single mode logging, you can use the SQLUtil RESTORE PARTIAL command to do a partial recovery of the DBEnvironment. You can recover just those DBEFiles that were damaged by the crash. Here is the procedure to use once the damaged drive is replaced:
|
|