RE: Urgent!!Data lost

From: Theodoros Demosthenous <theodoros_at_edams.com>
Date: Thu, 20 Jun 2002 06:08:31 -0800
Message-ID: <F001.00482900.20020620060831@fatcity.com>

There is a way:

1. Export and Backup existing database and all related files.
2. Restore your cold back up
3. Startup mount the database
4. Recover the database using the UNTIL option. You can define the time prior the table deletion.

Drawbacks:
1. you will have to insert again all data from that point onwards.

Regards
Theodoros

-----Original Message-----

Sent: 20 June 2002 16:18
To: Multiple recipients of list ORACLE-L

Hello
  we have lost one table data and we need to recover them, urgently.   Situation details:

  *We have a cold backup DB one month ago
  *Database in archive log mode
  *We don´t have export files

  We know our situation is extremely and it problably would be very difficult to
  recover them but we´d want to know if there is any way to do it.  Thanks a lot
--

---

Beatriz Martínez Jiménez Ingeniera Informática Tfno: 983 546646 beamar_at_cidaut.es
Fundación CIDAUT
Centro de Investigación y desarrollo en Automoción Parque Tecnológico de Boecillo, p.209. 47151 Boecillo, Valladolid.

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=   INET: beamar_at_cidaut.es

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: Theodoros Demosthenous
  INET: theodoros_at_edams.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). Received on Thu Jun 20 2002 - 09:08:31 CDT