You are right Rahul. Oracle determines if recovery is necessary by comparing the SCN of the datafiles with the control file. This is part of what goes on when a database opens. The log sequence numbers and the SCN range associated with each log file are stored in the control file also, I believe. List, please correct me if I am wrong.
Lisa
-----Original Message-----
From: Rahul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 3:06 AM
To: 'Koivu, Lisa'; 'Oracle List I'
Subject: RE: identify which logs are need to start recovery
Lisa/List,
when we restore a datafile from a backup, oracle will check the change# in
the header of the datafile
and will try to match it with the one in the controlfile, correct ? that's
how oracle will know that the file
is out-of-sync, now oracle will prompt from the change# as well as the log
sequence number to apply !!
from where does it get the log sequence number ? is it sotred in each
datafile ? or oralce queries it
from v$log_history ?
Rahul
> ----------
> From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 29, 2001 12:02 PM
> To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
> Subject: RE: identify which logs are need to start recovery
>
> Hi Rahul,
>
> I'm not sure if there's a v$ view that will tell you, I remember looking
> for this myself.
> However if you initiate recovery it will ask for the appropriate arclog,
> and you can always cancel out. During testing, I found that it will ask
> for every single one since the backup set from which you restored your
> datafile, regardless of whether or not it needs it (in this case, the
> datafile that was lost didn't contain any tables that had changed since
> the last backup. Go figure).
>
> HTH
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> [EMAIL PROTECTED]
>
> NeoMedia
>
> 2201 Second St., Suite 600
> Fort Myers, FL 33901, USA
> Phone: 941-337-3434
> Fax: 941-337-3668
> www.neom.com < http://www.neom.com>
> www.paperclick.com < http://www.paperclick.com>
> www.qode.com < http://www.qode.com>
>
> P a p e r C l i c k . c o m < http://www.paperclick.com/home.htm>
>
>
>
> Enter Your PaperClick Code Here!
>
>
>
>
> -----Original Message-----
> From: Rahul [ mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 11:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: identify which logs are need to start recovery
>
>
> usually i keep 2-3 previous archived logs, after switching and starting
> the
> hotbackup...
>
> but is there a v$ view to show which logs are needed to start the recovery
> ?
>
> TIA
>
> Rahul
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
