Fwd: Finding SCN during recovery

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Sep 2004 12:36:44 -0400

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/

Other related posts: