Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

sequence number in filenames


When DB dumps next segment of its log, new files are named autolog_name.XXX, where XXX is my problem. I thought that when I perform full backup, this number will reset and start with "001" but it did not

How can I reset this sequence number in filenames generated by autolog?

Former Member

> Hello,


> I agree that DB won't know which is correct. But if I

> make full DB backup and keep it safe (1), old log

> backup are useless,

Nope - you can always use an "older" backup and apply the archive logs, this is the same as using a newer backup and use newer archivelogs.

> so I thought that I can start

> numerating backup files from "001" again. I change

> name of autolog media after every successfull full

> backup, so there files would not be overwritten

> anyway.


If you have a problem with the backup for whatever reason, you won't be easily be able to recover an "older" one with that scenario. I have no idea, what problem you have with the "filenamenumbers" but if that is ok for you it's for me too



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question