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