| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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>
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: RahulReceived on Wed Mar 28 2001 - 23:12:21 CST
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).
 |
 |