Hi Hannes, > 16:42 Full backup (migration) > 16:44 Dataset 1 deleted > 16:52 Dataset 2 deleted > 16:53 db_cold > > Now starting different test with restore: > - Restore backup until 16:47 (db_warm) ==> dataset 1 is available, > dataset 2 not (Ok)
Are you sure? Shouldn't that be dataset 1 unavailable, dataset2 available? > - db_cold > - Restore backup until 16:43 ==> dataset 1 and dataset 2 are available > (Ok) > - db_cold > - Restore backup until 16:53 ==> dataset 1 and dataset 2 are available > (!!! Not Ok !!! or ?) > - db_cold > - Restore backup until 16:48 ==> dataset 1 and dataset 2 are available > (!!! Not Ok !!! or ?) > > Could it be that after going back into the past with a recovery it is > afterwards not possible to restore a later version with the same log? Yes, at least if you don't use log backups. If you "recover/restart until" the database is forgetting about everything what happened after that. So to say, it is as if nothing happened on the db after the until time. If you really need to switch between different database states, you should backup your log (before starting a recovery) and with the help of these log backups you can then go back to any state you had before. Tilo Heinrich SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
