> -----Original Message----- > From: Martin Cordova S. [mailto:[EMAIL PROTECTED] > Sent: Montag, 9. Juni 2003 23:34 > To: [EMAIL PROTECTED] > Subject: Restore procedure questions... > > > Hi, I am using the demo db to experiment with backup/restore question. > > 1) If the data volume and log volume are deleted (diskD0001 > and diskL001 for > this demo db), what should be the script to recover assuming the last > complete data backup (datasave file) and one auto-log file available > (autosave.001)? db_admin util_connect util_execute init config recover_start datamediumname data recover_start logmediumname log 001 recover_ignore
> > 2) If my backup is 1 day old, same as my autosave.001, and > many of the last > transactions where in the log volume and were never flushed > to an autolog > file, but this volume is lost as the data volume, what can I > do? should I > have an interactive log too? some task that should run in > case autolog has > not run yet? what do you mean by an interactive log? If not yetz saved data is lost, then cannot be recovered. > > Any help very appreciated. > > I have been able to restore my data but droping the instance, > recreating it > with a special version of the create_db script, and then > running a full data > restore, but autolog is off and I don't know how to activate > it again using > dbmcli (autosave_on fails). when you dropped the database instance, then you have to create another (new) instance and can then restore your data and log into it AFTER issuing an "until_execute init config". regards, martin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
