NOT OT! - identify which logs are need to start recovery

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 29 Mar 2001 16:39:14 -0800
Message-ID: <F001.002DC7BC.20010329163525@fatcity.com>

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:rahul_at_ratelindo.co.id] 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: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).
>
>
Received on Thu Mar 29 2001 - 18:39:14 CST