incomplete tablespace recovery (Oracle9i, Win) ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: incomplete tablespace recovery (Oracle9i, Win) ...

  1. #1
    Join Date
    Apr 2007
    Posts
    3

    incomplete tablespace recovery (Oracle9i, Win) ...

    Hi,

    I'd like to recover an older tablespace (without touching any redolog). The following procedure seems to be appropriate:

    1. alter tablespace xxx offline;
    2. recover tablespace xxx until cancel;
    2b. Canceling immediately.
    3. alter tablespace xxx online;

    There is no need to mention, that it doesn't work, isn't it? "Recover tablespace" doesn't seem to feel familiar with an option like "until cancel". Does anybody have an idea, how to do it right?

    Yours sincerely Sysadv

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you cant restore a tablespace to an old point in time in the same database it came from, it wont be consistent with the rest of the database.

    If you want to do that you must restore it to another instance and transport the tablespace

  3. #3
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    in short, TSPITR
    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

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