Help, Dropped some users and all its objects on a Production Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Help, Dropped some users and all its objects on a Production Database

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,

    I dropped some users along with all their objects on a production database thinking that I am working on a Test database.

    How Do I recover it to the point in time without losing any data.

    Just for your information I take a daily Cold backup.

    Please Suggest.

    Thanks
    Anurag
    Appreciation is a wonderful thing;
    It makes what is excellent in others belong to us as well.


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Is your DB in archive mode? Then recover the cold backup and then apply all those archive logs to the point that you droped the users.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2000
    Posts
    462
    1. create a second database using your backups.
    2. export the user and all objects
    3. import into production instance.

    Oracle DBA and Developer

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