If you do not have TURBO STORE and must do a static backup of your DBEnvironment, you can use the BEGIN ARCHIVE statement in conjunction with and immediately prior to the COMMIT ARCHIVE statement to start a new archive log file before a DBEnvironment is backed up. However, if you have TURBO STORE, the recommended approach to initiate archive logging is to use the SQLUtil
STOREONLINE command, or to use the ARCHIVE option with the START DBE NEWLOG statement.
Scope |
 |
ISQL or Application Programs
SQL Syntax |
 |
Description |
 |
You can turn archive mode off only by using the START DBE NEWLOG statement.
A backup copy of a DBEnvironment and an archive log file can be used for rollforward recovery when database files are physically damaged. In this type of recovery, you load a backup copy of the DBEnvironment, then issue the SQLUtil SETUPRECOVERY, RECOVERLOG, and ENDRECOVERY
commands. You may also need to use RESCUELOG.
Use the following method to create a new archive log and a static backup of the DBEnvironment:
Issue the BEGIN ARCHIVE statement, then the COMMIT ARCHIVE statement, to write an archive record in the rollforward log. The archive record indicates the point from which rollforward recovery can begin.
Use the SQLUtil STORE command to make a static backup copy of the DBEnvironment. The DBEnvironment must be stopped and remain stopped while you are making the static backup copy if you are using STORE. This procedure does not turn the archive flag in the DBECon file on or off.
You cannot use STORE from an application program, since it is an SQLUtil command.
Refer to the ALLBASE/SQL Database Administration Guide for detailed backup and recovery procedures and recommended practices.
Authorization |
 |
You must have DBA authority to use this statement.