STOREONLINE

Backs up a DBEnvironment to tape or serial disk and enables archive logging if it is not already in effect.

Scope

SQLUtil

SQLUtil Syntax

>> STOREONLINE DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord To File Name: StoreFileName

Parameters

DBEnvironmentName: is the name of the DBEnvironment to be stored. The DBEnvironment name can be an absolute pathname or a pathname relative to your current working directory; however, the name must be entered exactly the same way when the DBEnvironment is restored.
MaintenanceWord: is the maintenance word.
StoreFileName: is the absolute pathname of the backup tape or disk file. Relative pathnames are not allowed. The maximum length of a pathname is 44 bytes.

Description

STOREONLINE allows the user to create a backup copy of the DBECon file and all DBEFiles of a DBEnvironment. Note that log files are not stored. If more than one volume is required to store the DBEnvironment, a request will be displayed on the console. The next tape can then be mounted.
When you execute STOREONLINE you should be in the directory which contains the DBECon file and the SYSTEM DBEFileSet. If you must later restore the DBEnvironment, you must be in the same directory from which the DBEnvironment was stored.
You issue the STOREONLINE command when the DBEnvironment is in normal use. If archive logging has not previously been in effect, this command enables it.
The following message appears after the STOREONLINE is complete:
DBEnvironment stored.




	CAUTION: In order for an online backup to be of use for rollforward recovery, all logs containing transactions that were active during the execution of the STOREONLINE command must be available at recovery time. Without all the logs, the backup is worthless. This means that after the STOREONLINE command completes, you should do a STORELOG as soon as possible on any log files that contained active transactions during the time you did the STOREONLINE. The range of sequence numbers of the log files containing transactions active during the STOREONLINE process is indicated at the completion of STOREONLINE. Both the beginning and ending archive log sequence numbers are displayed. You must store all log files in that range to be able to do roll forward recovery, later. If there is a media failure involving the device containing the log files active during the STOREONLINE, and if the failure occurs before the files have been backed up, the DBEnvironment backup will not be usable. For the greatest protection, use dual logging with the dual files on different disk drives.

Authorization

You must be the DBECreator or superuser or supply the correct maintenance word to use this command.

Example

   >> storeonline

   DBEnvironment Name:  PartsDBE

   Maintenance Word:  MaintWd

   To File Name:  /dev/rmt/0h



   DBEnvironment stored.



   Begin Archive Log Sequence Number            2

   End Archive Log Sequence Number              3