Hello Bettina, >it works fine (no errors), but the data is the same as >in the current state.
That is because the log information that is still available on your log volume is used during the restart. To get the desired effect you can: A) reinstall the database with (stop after "INIT CONFIG", do not start the database into mode ONLINE) and recover the first data backup B) recover the first data backup and restart until a wanted point in time. If the needed log backup is not available anymore on the log volume, recover your log backups until the wanted point in time. Best Regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: beesic [mailto:[EMAIL PROTECTED] Sent: Montag, 17. M�rz 2003 15:30 To: [EMAIL PROTECTED] Subject: dbmcli: backup/recover Hi, I'm trying to do some backup/recovery tests with the test database TST74. I use dbmcli to create a backup medium: dbmcli -d TST74 -u dba,dba medium_put data-dump /home/sapdb/TST74/mydump.dmp FILE DATA 0 8 YES and to start the backup: dbmcli -d TST74 -u dba,dba -uUTL -c backup_start data-dump Having done so I change some data in TST74 and then create another backup medium (data-dump2 in mydump2.dmp) with the current db state. The log mode is "autolog". When trying to restore the first backup (data-dump) dbmcli -d TST74 -u dba,dba -uUTL -c recover_start data-dump it works fine (no errors), but the data is the same as in the current state. How can I save complete database instances at a special time and load them using the dbmcli commands? Regards, Bettina __________________________________________________________________ Gesendet von Yahoo! Mail - http://mail.yahoo.de Bis zu 100 MB Speicher bei http://premiummail.yahoo.de _______________________________________________ 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
