> -----Original Message-----
> From: Mundy, Nicholas S-PN EXT
> [mailto:[EMAIL PROTECTED]]
> Sent: Mittwoch, 18. Dezember 2002 15:37
> To: [EMAIL PROTECTED]
> Subject: Nomenclature of Autologs
>
>
> Hallo,
> we have AUTOLOG turned on and perform regular full data
> backups in WARM mode. Is there any way (apart from the data
> created), maybe in SQL? to identify which log segs come after
> which full database backup?
> The log segment backups are numbered SID.001, SID.002 etc,
> how far does this numbering go up? How do you reset it to .001?
> Thanks
> Nick Mundy
The dbmcli-command backup_history_list -r LAST gives information
about the last databackup and the log-backups which are necessary
for a full recovery.
If you need information for a specific backup, you has to retrieve
the key of the backup by using
backup_history_list -l label_of_the_backup
and the get the information about the necessary log-backups by
backup_history_list -r key
The numbering of the saved log-segments cannot be reseted, because
the segments have to be unique in the log-backup-history. The numbering
is only limited by the size of the filename (including the number). The
numbering will change from 3-digits to 4-digits and so on as necessary.
Regards, Martin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
