Urgent, Recovery

[sree_sri]

Somebody dropped one application user. That user is a owner of some application tables. Anybody have idea! How to find out? I mean can we know who dropped that user?

I am going to do point-in-time recovery,

I copied all the backup-files from yesterday,

I am keeping the current control file,current redo-log files.

any steps please

[Kishore]

You are in the right path. Recover till just before the failure time.

[aarganesh]

-To find the user check in alertlog file, or if the system hasn't been shutdown yet, check v$sqltext DPT.
-ok point in time recovery works out only if U'r DB is in archive mode.
-make sure U take a cold backup after shutting the database normaly, just in case of any issues and to maintain database consistency.