how to restore database bk to an other dababase name

H

hubnb

New Member
hello -
1、I have probkup online mfgprod
file list:
10041001
.........
10041009
100410backuplist
9 files
2、restore database
prorest 10041001 mfgbuff < 100410backuplist
3、Corrupt block detected when reading from database. (4229)
SYSTEM ERROR: wrong dbkey in block. Found 0, should be 9728 in area 6 (1124)
** Save file named core for analysis by Progress Software Corporation. (439)
Quit(coredump)
4、mfgbuff_11.d1 but can't creat mfgbuff_11.d2,mfgbuff_11.d3
5 、haw to restore currency.

thanks.
 
1. Do you have a mfgbuff.st file thats similar to mfgprod (except for the extent filenames and location).
2. prostrct create mfgbuff mfgbuff.st
3. prorest <new database name> <database backup name>
so for you it would be
prorest mfgbuff 10041001 < 100410backuplist

HTH
 
The way you was trying to restore the backup was correct. Now, as per my understanding the problem is there with your backup file.
With ths backup file even if you try to restore with same name, then also it will not work.

So, i will suggest to have the backup again & try the same way you was trying to do this. Or with taking the backup once again is not possible then there should be different approach for DB recovery as some of your DB extents got corrupted.

& after that try the way Vinod has explained i.e with the help of the Original .st file of mfgprod(should be mfgprod.st) & make changes in that .st file i.e rename mfgprod as mfgbuff & do the restoring of DB.
 
You must log in or register to reply here.
Back
Top