Recover a dropped schema - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 21

Thread: Recover a dropped schema

  1. #11
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Yes. That's an excellent idea and it sounds like you have the resources.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #12
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Originally posted by svk
    If the objects for this schema were indeed located in isolated tablespace(s), your recovery work is simpler. You will only need to restore datafiles for that tablespace(s) and rollback/undo.
    My concern about this way is that some objects are not physically sitting in the specified datafiles and they are in system tablespace like the synonyms or procedures.... I think only the tables and indexes in the specified datafiles.

  3. #13
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by KenEwald
    Can you?

    re-create the user
    take the tablespace offline
    copy the db files from backup
    recover tablespace until time
    bring tablespace online
    im pretty sure that wouldnt work because the user id will be different and objects belong to that id

  4. #14
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by Lily_Liu_2004
    My concern about this way is that some objects are not physically sitting in the specified datafiles and they are in system tablespace like the synonyms or procedures.... I think only the tables and indexes in the specified datafiles.
    restore a full backup somewhere, roll forward to right before it was dropped (using the time)

    export / import

  5. #15
    Join Date
    Jul 2000
    Posts
    521
    My concern about this way is that some objects are not physically sitting in the specified datafiles and they are in system tablespace like the synonyms or procedures.... I think only the tables and indexes in the specified datafiles.
    I missed mentioning that when you do a partial recovery, you will of sourse need SYSTEM tablespace datafiles.

    How big is the db ? If not too big, doing recovery work on entire database may be easier.

    And, doing all this in a NEW database is the only way to do it.
    svk

  6. #16
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Would 10g flashback recover a dropped user?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  7. #17
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    flashback a database, hmm im guessing that would

  8. #18
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by davey23uk
    restore a full backup somewhere, roll forward to right before it was dropped (using the time)

    export / import
    Yes, this is how I would do it.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #19
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    By KenEwald:
    Next to worst case scenario is that you have to recover the whole database to PIT and loose anything between the user drop and now
    Why would you do that in case a schema is dropped??
    The best thing would br TSPITR, where you recover the tablespace in a cloned instance use transport tablespaces option to bring it back.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  10. #20
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by simply_dba
    By KenEwald:

    Why would you do that in case a schema is dropped??
    The best thing would br TSPITR, where you recover the tablespace in a cloned instance use transport tablespaces option to bring it back.
    and how would that re-create the user?

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