Kbase P125080: Cannot restore backup to remote device, error 7112
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/07/2008 |
|
Status: Verified
SYMPTOM(s):
Database cannot be restored, error 7112
bkForEachExtent: buffer too small - need . (7112)
prostrct unlock fails with error 6945
Prostrct unlock record buffer too small. (6945)
restoring database to a mapped drive
File <filename> is on a remote device. (9466)
FACT(s) (Environment):
Progress/OpenEdge Versions
All Supported Operating Systems
CAUSE:
The .db is being created on the remote device, but the database files are being created locally. Moreover it is not the intent to create these files locally as (in this case) there is no space on the local server for these files.
FIX:
Due to the 'complex' nature of this environment, the instructions below are formatted by way of example for a sports2000 database.
assume:
\\server1\db is where the backup file volumes are, mapped-drive Y:\
\\server2\Oe10 is where the Progress | OpenEdge installation is
\\server3\tt is where the database needs to be restored, mapped-drive X:\.
1.) Start by cleaning down the past failure to restore. This includes all instances of .db and database files.
[\\server2\Oe10 ]
2.) Create a structure file (dbname.st) LOCAL to server2 that includes all extents to be restored and their full path-name
# dbname.st
b X:\tt.b1
d "Schema Area":6,32;1 X:\dbname.d1
d "Employee":7,32;1 X:\dbname_7.d1
d "Inventory":8,32;1 X:\dbname_8.d1
d "Cust_Data":9,32;1 X:\dbname_9.d1 f 10240
d "Cust_Data":9,32;1 X:\dbname_9.d2
d "Cust_Index":10,32;1 X:\dbname_10.d1 f 512
d "Cust_Index":10,32;1 X:\dbname_10.d2
d "Order":11,32;1 X:\dbname_11.d1
d "Misc":12,32;1 X:\dbname_12.d1
3.) create a multivolume backup file feeder: dbname.rst is also LOCAL to server2
Y:\dbname1.bak
Y:\dbname2.bak
Y:\dbname3.bak
.. etc
4.) STEPS (please verify each step)
a.) create the database structure on the X drive
proenv> prostrct create X:\dbname dbname.st
b.) RENAME dbname.st dbname0.st
c.) restore backup
proenv> prorest X:\tt Y:\dbname0.bak < dbname.rst
d.) truncate bi file
proenv> proutil X:\dbname -C truncate bi
5.) start the remote database
proserve X:\dbname [+ parameters]
proshut X:\dbname -by