Bernd said: Start a recovery immediately after the "init config" step (without db_warm) with restoring a full data save.
This is exactly as general and vague as the SAPDB documentation is about this subject! I don't have a clue on how to begin doing this and from mails a have received from others on the list it seems that Backup and Restore information need to be seriously fixed and updated. Best regards Eiki ----- Original Message ----- From: "Vorsprach, Bernd" <[EMAIL PROTECTED]> To: "'Eirikur Sveinn Hrafnsson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 6:27 AM Subject: RE: Help! emergency : Recovery with autosave files only > From: Eirikur Sveinn Hrafnsson [mailto:[EMAIL PROTECTED]] > > > By a mistake a database with two user spaces and lots of data was > > dropped and a new one with same name created! > > > All I have of the original database which is on a linux server are 25 > > autosave files. When probing these files with a text editor I can see > > lots of data in them from both of these user spaces! > > The autosave files include the changes of your database written > to the log. They do not include the content of your database > when autosave starts. > > > I have tried to restore them using restore from medium etc. but run > > into numerous problem. > > > 1. tried to create new database with the same name on windows 2000. > > Found out that sapdb can't be restored from linux > to nt : ( > > Yes, backups are not independent from the os. > > > 2. tried restoring to a new database on linux with a different > > name but got the error "failed: backup from another database" > > or something like that. > > Start a recovery immediately after the "init config" step (without > db_warm) with restoring a full data save. > > > 3. dropped the database that overwrote the original one and created a new > one > > with the same name and tried again. This time I get "can't open > devspace > > please correct and try again" > > This looks like another problem. Check the knldiag file for more infomation. > > Summary: > With autosaves only you can not restore a totally destroyed database. > You will need at least one full data backup and a series of autosaves > matching to the data backup. > > Bernd > -- > SAP Labs Berlin > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
