Thanks Mladen, been there looked up, but the numbers that I see are between first_change# and next_change# . The question is how does oracle find that this is the number that I need to start recovery from?? Raj On Thu, 9 Sep 2004 12:05:53 -0400, Gogala, Mladen <mladen.gogala@xxxxxxxx> wrote: > That change can probably be found in one of rhe redo log archives. > There is a table called V$ARCHIVED_LOG which has columns FIRST_CHANGE > and NEXT_CHANGE describing change numbers. You might want to take a peek > in the reference manual for more. > -- ------------------------------ -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/