Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: Finding SCN during recovery
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_at_aetn.com> 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_at_freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/Received on Thu Sep 09 2004 - 11:33:52 CDT