No, obviously not. :-)
Jill.Drocea_at_VerizonWireless.com wrote:
> select SEQUENCE#, resetlogs_change#, resetlogs_time from v$log_history
>
> 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?
>
--
Regards
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 03 2006 - 15:36:01 CST
