Table recovery question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Table recovery question

  1. #1
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204

    Table recovery question

    I need to recover a single table that was dropped last week.

    The 9.2.0.4 (on RedHat) database is in archivelogmode and a full database backup is done every Sat. Every other night I do archivelog backups.

    My problem is that the tablespace the table was in is online and in use. So I can't just recover the tablespace.

    Is my only option to recover that tablespace to a new database? I'd really like to recover that table alone and to the existing database.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Table recovery question

    Originally posted by KenEwald
    I'd really like to recover that table alone and to the existing database.
    I'll bet you would. Unfortunately, the only way I see you can do it is to restore the relavent files & tablespaces (control, system, undo, your ts, etc) on another box, recover to just before the object was dropped, and export/import.
    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."

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