Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recovery without backup.

Re: Recovery without backup.

From: Ron Rogers <>
Date: Wed, 08 Aug 2001 12:18:16 -0700
Message-ID: <>

 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 mm

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

73 Princeton Street
North, Chelmsford 01863  

Please see the official ORACLE-L FAQ:
Author: Ron Rogers

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: (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

Original text of this message