Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recover erased records.
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