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

In <blai5j$6gi$1_at_reader2.panix.com> Stan Brown <stanb_at_panix.com> writes:

>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?

A bit more data here. v$backup list the datafile in questions as:

        10 RECOVER READ WRITE  108474673   20971520   20971520
		/db_local1/oradata/pwhse/tables/config.dbf
				   

And I tried this:

SVRMGR> recover database until cancel ;
Media recovery complete.

But ifile 10 is still listed in "RECOVER" mode.

Do I need to place it back ONLINE first? If so how can I do this?

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