> -----Original Message----- > From: Christian Ullrich [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 7:26 PM > To: [EMAIL PROTECTED] > Subject: How to restore a database? > > > As the subject leads to expect, this is probably a very > stupid question, which is likely to be answered somewhere in > the documentation or the list's archives, but I have not found it yet. > > I'm currently experimenting with backup and restore > procedures and have run into a slightly confusing problem: > > - I create an instance, operate on it and do a complete data backup. > - I continue to work on the instance and eventually decide that > something has gone wrong and that I need to revert to the previous > backup's state. > - I restore the backup and find that nothing has changed. Eh? > - I create another instance, restore the backup there and find > myself with precisely the data I expected. > > What happened? Did the database, after restoring the backup > to the original instance, automatically run the available > logs to bring the database up to the latest data? exactly. The log, which is still on the LogVolume (if it had been not yet overwritten) will be redone. You can avoid this by a restart until a specified point-in-time: db_online -u YYYYMMDD HHMMSS
> > - I turn off autolog and create another log backup medium. > - I perform some more operations on the database. > - I do a log backup, in order to purge the active log. > - I send the database into admin mode and remove the log backup > medium, so that all log information since the original complete > backup should be gone. > - I restore the complete backup. Again, I get the latest data, not > what was in the backup. > > What happened? Log is not deleted after you saved it. It is only "marked" for an overwrite if necessary. regards, Martin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
