| |
The standalone dbstore utility is similar to the dbctl dbstore command.
The main difference is that it allows to perform a dbstore operation
when the database server is not active or while the database server is
in on-line backup mode.
usage: dbstore [options] database archive_file|-
options:
-help - show usage (this list)
-u user - set user name
-p pswd - set password
-c cfg - server configuration file
-b size - Buffer cache size (MB)
-Z - compress archive file
Whereas dbctl dbstore uses the configured "server devices" when specifying the
target file for the dbstore operation, the standalone dbstore utility (running
outside the eloqdb server context) allows to specify the archive_file
explicitly (or use - for stdout, for example to pipe into gzip).
The options are:
- -help
- The -help option displays a brief help text.
- -u user
- The -u option specifies the database user (or a file
holding the database user and/or password).
Defaults to the dba user unless a default user is
specified with the EQ_DBUSER
environment variable.
- -p password
- The -p option may be used to specify the password
for the database user (or a file holding the password).
If not specified, the password is obtained using the
EQ_DBUSER
and/or EQ_DBPASSWORD
environment variables.
- -c eloqdb.cfg
- The -c option specifies the eloqdb configuration file.
The eloqdb configuration file is used to locate the database
volume files. If not specified the default eloqdb.cfg is used.
- -b size
- The -b option may be used to specify the size of internal buffer
cache (in MB). The default buffer cache used by dbstore is 5 MB.
- -Z
- If the -Z option is present, a compressed output file is created.
-
If the database server is in on-line backup mode the standalone
dbstore utility does not require exclusive access and may be performed
while the database is in use. This is a difference to dbctl dbstore.
-
The database user performing dbstore needs to either have DBA or OPERATOR
user privileges or be member of a database group with DADMIN privileges.
The following example stores the MyDB database into a compressed disk file:
dbstore -c eloqdb.cfg MyDB - | gzip -v >/var/tmp/MyDB.store.gz
# or else, as of Eloquence B.08.30 ...
dbstore -c eloqdb.cfg -Z MyDB /var/tmp/MyDB.store.gz
dbctl utility, specifically
dbstore and
dbrestore
commands
Article on
Database Backup
and recovery in the B.08.00 documentation.
|
|
