restore structure

Posted by bremmeyr on 18-Mar-2016 12:19

With a database backup file in hand that was created with probkup; how can the required ST be created? The intent is that the ST would be used with prorest to restore the DB? In addition can the values be accessed via AB\4gl code?

OpenEdge 11.5.1 64-bit Windows

- See more at: community.progress.com/.../23837

All Replies

Posted by marcv on 18-Mar-2016 13:27

You don't need an st file to do a restore, but it could be a problem if you are unsure of the db physical structure. If the paths are not available then the restore would fail or potentially they could be written to disk areas you might not want.

You can can use prorest to help you assemble the information needed to create a new ST and place the the physical files where you want, or create multiple extents for each are instead of one variable, which is the default if no st is provided.

prorest dbname <path to backuo file> -list  (*dbname can be anything -  you just need to specify something)

The output will show the information you need to format the lines in the st file - area names,  number, cluster size.

You'll need to do a some math to figure out how many extents are needed to create enough multiple extents required for each area if you do want multiple extents.

documentation.progress.com/.../

Posted by Alon Blich on 20-Mar-2016 06:25

you may want to check the backup system in the baksys/ directory, in the standard libraries project at the oehive.org.

the backup system exports and saves the .st file as part of every backup (and can use the .st file in restoration).

the backups are archived as .zip files (backups that are older than a requested time period are deleted).

the backups are saved as weekly full backups and daily incrementals.

supports after imaging.

supports log files and email alerts and reports (including warning and error notifcations like insufficient disk space).

supports restoration including restoration to point in time.

compatible with unix/linux and windows, version 9 and higher.

hth

Posted by bremmeyr on 22-Mar-2016 14:18

Alon, great. Thank you.

This thread is closed