STOREONLINE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
STOREONLINE
Backs up a DBEnvironment to tape and enables archive logging if it is not
already in effect.
Scope
SQLUtil
SQLUtil Syntax
[REV BEG]>> STOREONLINE [REV END] DBEnvironment Name: DBEnvironmentName
Maintenance Word: MaintenanceWord To File Name: StoreFileName
Parameters
DBEnvironmentName is the name of the DBEnvironment to be stored.
MaintenanceWord is the maintenance word.
StoreFileName is the device name for the tape device that will
receive the backup.
Description
* You must have TurboSTORE software on your system to use
STOREONLINE. If you do not have TurboSTORE, you must use the STORE
command.
* 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. No reply is necessary for the
continuation of the store on the new mount.
* When you execute STOREONLINE you should be in the group and
account which contains the DBECon file and the SYSTEM DBEFileSet.
If you must later restore the DBEnvironment, you must be in the
same group and account 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.
* STOREONLINE cannot be used if there are any pseudo-mapped files
configured in your system. Before using STOREONLINE, convert all
pseudo-mapped files back to ordinary mapped files using the
MOVEFILE command.
* 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, have SM capability, or supply the correct
maintenance word to use this command.
Example
>> storeonline
DBEnvironment Name: PartsDBE
Maintenance Word: MaintWd
To File Name: TAPE
DBEnvironment stored.
Begin Archive Log Sequence Number 2
End Archive Log Sequence Number 3
MPE/iX 5.5 Documentation