Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple? recovery question
Verna
You should investigate the Log Miner utility. This may enable you to unearth
your row.
BMC's PATROL DB-Logmaster is similar but Log Miner scores higher as it's
supplied with Oracle 8.1.5 +.
Needless to say, you should exercise great caution to ensure you have the correct data before you reinsert it.
Regards
Mike Hately
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 Wed May 24 2000 - 00:00:00 CDT