-
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
sree
-
You are in the right path. Recover till just before the failure time.
Thanks
Kishore Kumar
-
-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.
A Winner never Quits, A Quitter never Wins
Ganesh .R
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|