.
contact contact


dbstore utility

» Usage | Notes | Examples | See also
 
.
  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

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.

Notes

  • 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.

Examples

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

See also

dbctl utility, specifically dbstore and dbrestore commands

Article on Database Backup and recovery in the B.08.00 documentation.


 
 
 
  Privacy | Webmaster | Terms of use | Impressum Revision: 2018-12-05  
  Copyright © 1995-2021 Marxmeier Software AG