Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: Finding SCN during recovery

Fwd: Finding SCN during recovery

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 9 Sep 2004 12:36:44 -0400
Message-ID: <9177895d04090909367b08e634@mail.gmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US