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

Thread: Urgent, Recovery

  1. 05-24-2001, 01:00 PM #1
    sree_sri
    sree_sri is offline Member
    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
    Reply With Quote Reply With Quote
  2. 05-24-2001, 01:18 PM #2
    Kishore
    Kishore is offline Senior Member
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You are in the right path. Recover till just before the failure time.
    Thanks
    Kishore Kumar
    Reply With Quote Reply With Quote
  3. 05-25-2001, 01:11 AM #3
    aarganesh
    aarganesh is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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