RE: Recovery without backup.

I believe what was meant is having all archive logs since tablespace created, but not the datafiles.

I am going to look more into it over the weekend when I get a little break from the chaos.

"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  

-----Original Message-----
Sent: Wednesday, August 08, 2001 4:16 PM To: Multiple recipients of list ORACLE-L

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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  INET: cspence_at_FuelSpot.com

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