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:lkoivu_at_qode.com]
> Sent: Thursday, March 29, 2001 12:02 PM
> To: 'ORACLE-L_at_fatcity.com'; 'rahul_at_ratelindo.co.id'
> 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
> lkoivu_at_qode.com
>
> 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:rahul_at_ratelindo.co.id]
> 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: rahul_at_ratelindo.co.id
>
> 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: ListGuru_at_fatcity.com (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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

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: ListGuru_at_fatcity.com (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).