Re: Recover erased records.

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 13 Apr 2005 13:37:06 +0200
Message-ID: <d3j02f$p8c$1@news4.zwoll1.ov.home.nl>

Mª Carmen Lozano wrote:
> I yesterday erased of a table 200 registries by error, would like to know
> that I can do for being able to recover them. If there is some file that
> keeps all the erased information, or daily a backup is made with the command
> cpio of UNIX.
> Can somebody help me?
> Regards,
> Noriepa
>
>

You have a cold backup (I hope), if I understand the reference to cpio correctly.

Which version, and how long ago exactly? There is a flashback area in 10g, if that is your version, that keeps a state of the database until so much time ago.

Another possibility: exports - if you have one, get your table, or just your missing data, back.

If none of the above: get your cold backup of the day *before* yesterday.

Yesterdays backup does *not* have the missing entries anymore!

-- 
Regards,
Frank van Bortel

Received on Wed Apr 13 2005 - 06:37:06 CDT