Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recovery without backup.
Chris,
Good luck on the testing of the "new" feature that you heard about. But I think that
there needs to be some clarification stated about the "archivelogs". IF you have ALL
of the archivelogs that ever did anything with the tables in the datafile that you
delete ( I mean everything from creation to datafile delete time) then I think that
you should be able to recreate the tables in the datafile with the archivelogs. If you
only have the updates or inserts for the tables then how are you going to recreate all
of the data and co a complete restore?
What archivelogs are you going to test with. The logs from yesterday after a backup
or logs from 2 weeks ago?
I think that what you heard is not what they ment. If all you need to recreate a
datafile is the controll file and archivelogs then the backups of today could be
history. Why backup 70+ GIG of datafiles if I only have to retain my 2 MEG of
archivelogs.
Please post your tests and results.
ROR mª¿ªm
>>> cspence_at_FuelSpot.com 08/08/01 03:21PM >>>
I don't know much about this feature, but someone mentioned in 8.1.7 you can
recover a datafile even without a backup as long as you have a control file
that knew about it and the archive logs.
Anyone give this a try? I am going to attempt this weekend on my test box.
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org 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 Wed Aug 08 2001 - 14:18:16 CDT