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). 
> 
> 
-- 
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).

Reply via email to