Re: Lost data

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

How was the backup done? If you just copied the datafiles while the database was up without placing the tablespaces in backup mode, there's no guarantee you can recover. If you shut the database down before doing the backup, you can restore the files and get back to the point in time of the backup. If you also have all of the redo logs since the backup, you might be able to do point in time recovery to bring the database back to the state it was in before the accident. The latter should probably be done by a DBA though.

"Patrick Hardy" <el_lasso_at_hotmail.com> wrote in message news:Q48f8.30491$xz6.1406722_at_weber.videotron.net...
> Hi, someone made a a mistake and deleted an important table...
> then, second error, didn't do the rollback...
>
> Those data were on a data server not really important and not
> managed by the DB guys so the only backup we could have was a
> HardDisk backup..
>
> So i have a orant directory with all the files in it and i'd like
> to recover the data in any format even if it means reenter all data
> by one by one...
>
> Thanks a lot
>
> Pat
> el_lasso_at_hotmail.com
>
>
>
>

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPH0Tlmm5A4kkb4ZsEQLEqwCgvQn+Cq5rr0E1prmPYZ3n1f7wAIMAoOMq +1ndWqn6UKaPwmydldTH+ch6
=aXtc
-----END PGP SIGNATURE----- Received on Wed Feb 27 2002 - 11:12:58 CST