Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Recover erased records.

Re: Recover erased records.

From: MĒ Carmen Lozano <noriepa_at_teleline.es>
Date: Wed, 13 Apr 2005 12:34:57 GMT
Message-ID: <Rl87e.817155$q7.1066505@telenews.teleline.es>


I have version 9.0.1. the problem is that as soon as I have handled oracle and not by where to begin.
Can you help me?
A greeting:
Noriepa
"Frank van Bortel" <fvanbortel_at_netscape.net> escribiķ en el mensaje news:d3j02f$p8c$1_at_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 - 07:34:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US