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