> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 4. Juni 2003 09:53 > To: [EMAIL PROTECTED] > Subject: restore > > > Hi SAP Team, > > I want to restore the following backups with the DBMCLI (GUI is not an > option): > > Example: > > Nr. Typ Label Version > 1 DAT Nase 001 > 2 PAG IncNase 001 > 3 Pag IncNase 002 > 4 DAT Kolben 002 > 5 PAG IncKolben 003 > 6 PAG IncKolben 004 > 7 PAG IncKolben 005 > 8 PAG IncKolben 006 > 9 PAG IncKolben 007 > 10 LOG LogKolben 002 > 11 LOG LogKolben 003 > > (The nr. column is just for better understanding what I want > to do, it has > no meaning in SAPDB) > > It's no problem to restore all mediums begining by the last > complete backup > (nr. 4-11). > > Now my questions: > > 1.) exists a recovery command which can handle the > information from the > "backu_history -r LAST" directly, e.g. some kind of > "recovery_last_backup > <medium>"? > > 2.) another problem: how can I restore only the datas BEFORE > nr.4, e.g. > because all datas beyond this backup are invalid. > > I've tried the following: > > dbmcli -uUTL -d test -u DBO,kennwort > util_execute INIT CONFIG > recover_start Nase DAT 001 > db_online > > The documentation says, versioning is only available for > logbackups. But how > is it posible to restore a earlier complete backup with the > same mediumlabel > like all my other complete backups?
If you defined your medium with the flag overwrite, then a backup overwrites the previous one. If you didn't copy it to another location before, then it is lost. If the overwrite flag is not set (default), then you _must_ move the backup-file before the backup can proceed. For a recovery just move your saved file onto the correct location (defined in the medium) and start the recovery. regards, Martin > > Thx for your effort > > Chr.Zink > > -- > +++ GMX - Mail, Messaging & more http://www.gmx.net +++ > Bitte l�cheln! Fotogalerie online mit GMX ohne eigene Homepage! > > _______________________________________________ > 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
