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

Thread: Table recovery question

  1. 04-19-2004, 10:15 AM #1
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  2. 04-19-2004, 10:27 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    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