Kbase P49920: How to automate the restore a database backup on UNIX that contained multiple backup files?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/10/2005 |
|
Status: Verified
GOAL:
How to automate the restore a database backup on UNIX that contained multiple backup files?
GOAL:
How to do an unattended restore when you have multiple backup files?
FIX:
1) Create an input file that contains the backup file names and locations starting with the second file.
For Example.
Create a file called input. This file contains the following entries.
./dbname2.bak
./dbname3.bak
./dbname4.bak
2) Issue the prorest command with the first backup file and redirect the input response file:
prorest dbname dbname.bak < input
The restore should proceed automatically:
tssolar(usr): prorest dbname dbname.bak < input
Start of extending target DB to needed size...
This is a full backup of /pathtodatabase/dbname.db. (6759)
This backup was taken day month date hh:mm:ss yyyy. (6760)
The blocksize is 1024. (6994)
It will require a minimum of 4211 blocks to restore.(6763)
Start of restoring the target DB...
Please enter next device/file name or type "quit" to exit:
Please enter next device/file name or type "quit" to exit:
Please enter next device/file name or type "quit" to exit:
Read 2976 db blocks in 00:00:33