ad 2) You can define the LOG_SEGMENT_SIZE smaller so the autologbackup task will backup more closely to the current time.
To avoid the loss of even the newest log which is not yet backuped you have to use hard- or software mirroring of the log volume. kind regards Uwe > -----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)? > > 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? > > 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). > > Regards, > Martin > > > > _______________________________________________ > 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
