> And what to do if: > data volume: ... > log volume: ... > medium: > medium_put auto autosave FILE AUTO > medium_put data datasave FILE DATA 0 8 YES" > medium_put data1 datasave1 FILE DATA 0 8" > medium_put data2 datasave2 FILE DATA 0 8" > LogMode Autosave is ON. > > And I performed Complete Data Backup at different dates: > "backup_start data1 DATA" - 2004/01/01 12:00:00 > "backup_start data2 DATA" - 2004/01/02 12:00:00 > > And then I recover the "2004/01/02 12:00:00" state: > "recover_start data2 DATA" - OK > "db_restartinfo" - Restartable 1(database restartable) > "db_online -u 20040102 120000" - OK > > After that I have to do Complete Data Backup to switch DB > to "LogMode > Autosave is ON" state (because the backup history is interrupted) > "backup_start data DATA" - OK This means that a new DBIdentifier is set for the data- and the logvolumes.
> > Now I want to restore "2004/01/01 12:00:00" state: > "recover_start data1 DATA" - OK > "db_restartinfo" - Restartable 0(database not restartable) > I can`t recover my log with "recover_start auto LOG > UNTIL 20040101 > 120000" because I don`t have log backup. You should save your log before you begin a time-in-point recovery/restart: db_admin util_connect backup_start auto log Then you have all neccessary data and log-backups for a complete recovery with arbitrary points in time. regards, martin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
