Dear Tilo,
thanks once more. Now it's clear for me (hope also for others).
"Heinrich, Tilo" wrote:
>
> 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?
You're right. Was a typing error!
> > - 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.
Thanks
Hannes
--
Hannes Degenhart GPS - Gesellschaft zur Pruefung von Software mbH
Hoervelsinger Weg 54 D - 89081 Ulm - Germany
Pho. +49 731 96657 14 Fax. +49 731 96657 57
mailto:[EMAIL PROTECTED] Web: http://www.gps-ulm.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
