Hi Scott, Scott Murray wrote: > > 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] > > 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] > > I don't understand how to get the LOG back. > > I appreciated any help.
for short, this log recovery is done - in your case - automatically, because as you already stated, all the log which is relevant, is still in the log devspace. Otherwise you would have to recover also log from the log backups. BTW, these log informations are restored into file structures in the data devspaces and the log devspaces are left untouched as the informations there are important for the final restart. Both sources of log (out of the data and log devspaces) are finally used to get the restart working. Therefore during restart the log recovery is done and the only thing you have to specify is the maximum time until the log should be recovered. You specify this time with the recover_start option UNTIL <date> <time>. The syntax is here http://www.sapdb.org/htmhelp/30/f7c7e95be311d4aa1500a0c9430730/content.htm Please take into account that the <date> and <time> should be >= the <date> <time> of the data backup. Hope this helps Ciao Ralf __________________________________________________________________ Dr. Ralf Czekalla mailto:[EMAIL PROTECTED] _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
