Hello Sven, if you have a data backup from 28.11.2002 and a Log Backup containing all log entries from the data backup up to 29.11.2002 10:00 and you have not backed up your log after 29.11.2002 10:00 and did not use Log Mode Demo and had no failure on the log devspace, you should be able to recover your database to 29.11.2002 12:00 as follows:
dbmcli ... -uUTL > recover_start <DataBackupMedium> DATA ... > recover_start <LogBackupMedium> LOG UNTIL 20021129 120000 At the end of the restore of the log backup, the database should find the log entries from 10:00 to 12:00 on the log devspace and should use them automatically. The database should be in state WARM/ONLINE after the second recover_start finished. Best Regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Siegler, Sven [mailto:[EMAIL PROTECTED]] Sent: Samstag, 30. November 2002 00:48 To: '[EMAIL PROTECTED]' Subject: Problem Recovering SAPDB UNTIL TIME Hello Community! I have an urgent Problem with an Database-Server running on SAPDB. Yesterday my System crashed and I wanted to restore the system. I have a full Backup from the night before (28.11.2002) and a LogFileBackup (29.11.2002 all Data till 10 o clock) from the same day. So far so good. I am able to restore the data from the full backup and process the LogFileBackup in. The last LogFileBackup is from 10 o clock. But I want to process in till 12 o clock. I have saved the Logfile from the Database before I made an Restore. Is it possible to read in the Database Logfile (not a Logfile Backup) and process it "UNTIL 20021129 120000". In Oracle you can give the OnlineLog to the Database as an Offlinelog and it gets all the data. I tried this in SAPDB, but this wont run. Any Ideas? Thanks for quick Help! Mit freundlichen Gruessen _____________________________________ Sven Siegler COMICS Informationssysteme Karlsruhe GmbH Badener Str. 3 76227 Karlsruhe Tel. +49 721 9435074 FAX +49 721 9435099 e-mail mailto:[EMAIL PROTECTED] _____________________________________ _______________________________________________ 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
