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

Thread: Backup

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    Backup

    Hi,

    How can I retrieve a dropped user along with data ?

    I have dropped a user yesterday at 3:00 pm. I have Hot Backup on 17th DEC. I don't have any export file .



    an immediate reply is requested.
    prasadvd@rediffmail.com
    Prasad

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    restore backup and apply archived logs till yesterday but of course you will lose evrything from yesterday to today

    or

    restore backup in another server apply archived logs till yesterday and export the user and import to database

  3. #3
    Join Date
    Nov 2002
    Posts
    115
    Hi,

    Can u give the steps clearly if u don't mind..



    Thanx.
    Prasad

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I mind, because its explained in much details than I can do in Oracle docs

    http://download-west.oracle.com/docs...a76993/toc.htm

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