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?
Markus Doehr replied
> 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
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