Urgent, Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Urgent, Recovery

  1. #1
    Join Date
    Feb 2001
    Posts
    203
    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

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You are in the right path. Recover till just before the failure time.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    -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
  •  


Click Here to Expand Forum to Full Width