Hi,
Shows the sequence# reset to 1 and the sequence number in my archive file name has been reset to 1. My log_archive_format is set to xyz_sid_%S_%t_%r.arc. Below you can see that my sequence number was reset.
Xyz_sid_0000000022_1_575652460.arc Xyz_sid_0000000001_1_578653176.arc
I expected a new instance_number without resetting the sequence number. Is my assumption correct?
Tanel.
-- //www.freelists.org/webpage/oracle-l