What version of Oracle? Are you archivelog mode? If Oracle 10g, is
flashback recovery enabled? Are you using Recovery Manager to control
the backup and recovery process?


cs


-----Original Message-----
From: Mangin LaVonne A
[mailto:oracledba-ezmlmshield-x27006185.[Email address protected]
Sent: Tuesday, November 01, 2005 9:59 AM
To: LazyDBA Discussion
Subject: URGENT: table recovery, losing data

Good Morning Gurus,

I have two problems for your expert dissection.

One: We have a student that deleted an entire table. I have a backup
that is just a little over a week old. Is there any way to recover just
that table from the backups instead of having to recover the entire
database? Can this be done without using the import/export mechanism?

Two: I have been making output files from this database for a couple of
weeks now. During the accounting phase (accounting in the sense of
checking the integrity of the files and making sure everyone/everything
is present in the files) I am finding that data that was entered
previously, is now not found in the database. I know that a commit was
done post-load of each datafile. Could it be that if a tablespace file
was full/maxed out, that the data would, in essence, disappear? Or would
I get some message upon loading that the data could not be loaded for
lack of space?

I cannot discount that something might have happened while the student
was remote logged in that caused a mishap in the loading. But I don't
have enough experience to understand what happened and why.

Thank you very much,
La Vonne Mangin
Univeristy of Iowa
Center for Statistical Genetics Research


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page