Kbase P119662: How to speed up prorest
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to speed up prorest
GOAL:
Why is prorest so slow on target (backup) machine
FIX:
To speed up prorest, make sure you are restoring the database within an existing database structure so that no new disk space needs to be acquired via the Operating System.
if an earlier copy of the database already exists, DO NOT run "prodel <db>" prior to the restore .
On Unix you can use the "pipe" to answer the question
Do you want to over write it? [y
]:
as per:
echo 'y' | prorest <dbname> <dbbackup>
If no earlier copy of the DB exists, then run "prostrct create <db>" while having the file "<db>.st" describing the database structure and listing its file locations.
Also, make sure you do have the same block size for the tape drive on target (backup) machine and on source (production) machine.