Skip to Content

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

sequence number in filenames

Hello,

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
replied

> 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

--

Markus

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