> -----Original Message----- > From: Ralf Liebenow [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 18, 2003 11:31 PM > To: [EMAIL PROTECTED] > Subject: Recovery Probs > > > > Hi ! > > I do a nightly BACKUP with: > -> util_connect > -> backup_start SAPDB_COMPLETE_DATA MIGRATION DATA > > Which gives me a full Backup file. > > Today I needed to restore the DB to a time some hours before, > but I could not manage it. I tried the following: > > -> db_offline > -> db_online -u 20031018 120000 > > Which did not work (I had actual Data so it was not rolled back), The data will not change due to the until-parameter. The database cannot perform a rollback of already committed transactions.
> Then I wanted to restore it to my nightly Data Backup Version: > [Described so within http://www.sapdb.org/7.4/pdf/backrec_eng.pdf] > > -> db_admin > -> util_connect > -> util_execute INIT CONFIG > -> recover_start SAPDB_COMPLETE_DATA DATA > -> db_online > > But after this, I had actual Data in my View, no rollback to > the last Backup done ... it seems the log is used, and I > don't know how to purge it, and restore the exact state of > the DB when the complete data backup has been written. The "init config" clears log-volumes and data-volumes. So there is nothing on the log to be re-done. Maybe you defined your data-backup-medium as overwrite and did overwrite it by accident? You can see this in the backup-history or in the timestamps of the restore data command. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
