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]

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.

Scott Murray


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to