> -----Original Message----- > From: Scott Murray [mailto:[EMAIL PROTECTED] > Sent: Montag, 10. M�rz 2003 18:41 > To: [EMAIL PROTECTED] > Subject: Recover the LOG > > > I create a db at 10am this morning, and in cmd file i define > these backups: > > echo medium_put completef %DATA%\%SID%\datasave FILE DATA 0 8 YES > > param.tmp > echo medium_put autosave %DATA%\%SID%\autosave FILE AUTO >> param.tmp > > it creates autosave.001 and datasave files in the specified > directory with > 'time modified' stamps of 10am. > > my datafile also has a stamp of 10am. > > i make random changes (inserts, updates, and deletes) until > 11:00am, and the > 'time modified' stamp on the autosave.001, datasave, and my > datafile remain > at 10:00. > > At this point (11am), how do I recover to 10:30am? > > I believe all my changes are in the LOG? How do I recover that? > > I have tried: > > dbmcli -uUTL -d mbm -u dbm,dbm db_restart -u 20030310 103000 > [and get a -24988 error]
This cannot work because during online mode there are savepoints written. If you restart the database the last savepoint is used and all the log in the log volume is used to recover to the last commit you ever executed. So your given timestamp is in the past but a database only can redo forward. > > I have tried: > db_cold > dbmcli -d mbm -u dbm,dbm -uUTL -c recover_start completef > db_warm > [this brings me back to 10:00am, not 10:30] > This is the right way. You have to set your data basis to the past and do a redo in time. I assume that after the data recovery you don't need your log backup because the db_warm worked so the database was online again. But I wrote it above. By default the complete log is used to recover to the last commit ever executed. So you have to use the data recovery to reset to 10h and the you have to use the until-date to restart to a specified point in time. regards Uwe > I don't understand how to get the LOG back. > > I appreciated any help. > > Scott Murray > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
