Re: HELP! Disappearing rows!?! DB corrupt?

Enable auditing (init.ora parameter audit_trail=true). Bounce the database.

Then in the database "audit delete on TABLE" where TABLE is your tablename. Monitor the audit trail for a while (see chapt 13 Server Admin Guide for more info).

I have never seen any sort of corruption cause rows to disappear overtime (or even just disappear, you would get an error message).

The audit trail will tell you who and when the row is being deleted. Be aware anyone with DBA can subvert the whole auditing process (and since they have "delete ANY table" can definitely delete from the table in question) if they really want to.

tillkahle_at_aol.com (TillKahle) wrote:

>Please help me!
 

>We have an Oracle 7.1.1.3 workgroup server running on
>Novell 3.12.
>A couple of weeks ago I had to shut down the instance
>brutally because a DML statement took over 3 hours
>and slowed the server down.
 

>Since that day, from one table (100 rows, 3 cols, 2 foreign
>keys, no triggers) rows keep disappearing (about 2 a day).
 

>I have recreated the table because I thought it might have
>suffered. The problem continued, so I revoked the right
>to modify that table from all users of the client software
>(only on client side, but the clients are pretty safe).
 

>Has anybody out there had similar problems? Any ideas
>about recovery tools in case the database is corrupted?
 

>I appreciate any ideas!
 

>Thanks,
 

>Till
>Hamburg

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government Received on Sat Dec 09 1995 - 00:00:00 CET