Database backup with OS utilities

« Go Back


EnvironmentProduct: Progress
Product: OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
Have a valid OS backup of your database
Make a database backup with OS utilities
Clarifying Information
Error Message
Defect/Enhancement Number
A valid backup is a backup that will allow you to restore your database.

When using an OS utility (cpio, tar, ..) to backup your database then it is important that
. your database is shutdown and is not accessed by any single-user client all the time the backup takes place
. you do not miss any file of your database

The database files will be just a <dbname>.bi and <dbname>.db for Progress V8 (as well as V6 and V7) single volume database, but there are more files for any V9 database or for multi-volume databases.
For a multi-volume database, the command "prostrct list <dbname>" will give you the list of its files..

You will find in the "<database>.st" file the localization of:
<dbname>.b1,<dbname>.b2, ....<dbname>.bN [ Primary Recovery Area, also called Before Image file ]
<dbname>.d1, <dbname>.d2, ....<dbname>.dX [ Schema Area ]
<dbname>_7.d1, <dbname>_7.d2, ..... [ User Area #7]...<dbname>_I.d1, <dbname>_I.d2, ..... [ User Area #I]

Make sure your have on your OS backup all the above files, plus the file <dbname>.db [ Control Area ].For version 8, you will have no User Area, i.e. no file <dbname>_I.dJ.
The files<dbname>.a1, ... <dbname>.aM [ After Image Area ]<dbname>.t1,... <dbname>.tN [ Transaction Log Area ]do not need to be included within your "database backup".
Was this article helpful?


Your feedback is appreciated.

Please tell us how we can make this article more useful.

Characters Remaining: 255