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

From: Stan Brown <stanb_at_panix.com>
Date: Tue, 30 Sep 2003 00:18:59 +0000 (UTC)
Message-ID: <blai5j$6gi$1@reader2.panix.com>

In <3F787C23.23B9FC5B_at_remove_spam.peasland.com> Brian Peasland <dba_at_remove_spam.peasland.com> writes:

>> >6. Take a complete backup
>>
>> Thanks!
>>
>> I'll give that a try just as soon as my backup tape finisehs. I'm close
>> enough to a working instance, that I think it is wise to take a snapshot
>> (cold) of it.

>That's why I included step #6. Take a backup right after you've got the
>thing restored, opened, and operational.

Hmm, spmething went awry here:

SVRMGR> RECOVER DATAFILE '/db_local1/oradata/pwhse/tables/config.dbf' UNTIL CACNEL;
ORA-00274: Illegal recovery option UNTIL

Any idea what I'm doing wrong here?

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin

Received on Mon Sep 29 2003 - 19:18:59 CDT