Re: Queries on V$archived log

Posted by ErmanArslansOracleBlog on May 31, 2018; 1:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Queries-on-V-archived-log-tp6127p6130.html

first_change# and next_change# are related with the SCN.

first_change# is the lowest SCN that appears in that archived log.
next_change# is the lowest SCN that appears in the next archived log.

So let's suppose, archivelog x 'sfirst_change# = 1
So let's suppose, archivelog x 's next_change# = 11

This means all the changes that are done from SCN 1 to 10(including 10) is in archivelog x.