Printable View
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
You are in the right path. Recover till just before the failure time.
-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.