Re: simple? recovery question

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/25
Message-ID: <DjaX4.208862$Tn4.1828523@news1.rdc2.pa.home.com>#1/1

To recover a row, you really need an export, not a recovery.

Also you can't use archivelogs without at least a hot/cold backup.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Verna Legaspi" <verna.legaspi_at_attws.com> wrote in message
news:8gf2ul$eha$1_at_redftp.redftp.attws.com...


> Hello,

>

> I need to recover just 1 row on a table in my database.  The row has been

> deleted since last week.  All I have for a backup is a nightly full DB

> export... so last week's full DB export has been replaced by last night's!

>

> Is there a chance for me to recover this table/row with just this?  I have

> archive redo logs, but unfortunately, I very much doubt I have a "cold"

> backup of my datafiles to apply them to.

>

> 8.1.5 on Solaris 2.6

>

> TIA,

> Verna

>

>

>

Received on Thu May 25 2000 - 00:00:00 CDT