Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to recover just one datafile/tablespace "until cancel"?

Re: Is it possible to recover just one datafile/tablespace "until cancel"?

From: Stan Brown <stanb_at_panix.com>
Date: Tue, 30 Sep 2003 12:28:17 +0000 (UTC)
Message-ID: <blbst1$i45$1@reader2.panix.com>

In <175e798aa64862e9dd4fda3297d7062d.20305_at_mygate.mailgate.org> "Thomas Schwickert" <schwickert_at_yahoo.com> writes:

>"Stan Brown" <stanb_at_panix.com> wrote in message
>news:bl9q7f$qj2$1_at_reader2.panix.com
 

>> Is it possible to recover _just one_ datafile (which coantins one
>> tablespace) using the until cancel option. The instnace is 7.3.4.5 if it
>> matters.
>>
>> If this is possible, could someone give me example ayntax, I seem to not
>> understand it.

>Hi,
 

>no, it isn't possible. The UNTIL CANCEL option is only
>for database recovery.
>What you want requieres
>-- recover your database with until cancel (e.g on another system)
>-- export your wanted data
>-- import it in your original system

Not meaning to challenge your GURUness :-) but is this an issue of my Oracle version being to old (7.3.4.5)? As some other people have sugested that I can do a recover until cancel on a specific datafile.

I'm genuinly interested in using this catastrophe as a learning experience, so please be gentel :-)

Thanks for the education.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin
Received on Tue Sep 30 2003 - 07:28:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US