Re: Resetlogs and new incarnation

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Jill.Drocea@xxxxxxxxxxxxxxxxxxx
  • Date: Tue, 03 Jan 2006 07:36:01 -0700

No, obviously not.      :-)

Jill.Drocea@xxxxxxxxxxxxxxxxxxx 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
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006