Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to recover just one datafile/tablespace "until cancel"?
You didn't really copy/paste the mis-spell "CACNEL", did you :)
-- "Stan Brown" <stanb_at_panix.com> wrote in message news:blai5j$6gi$1_at_reader2.panix.com...Received on Mon Sep 29 2003 - 23:29:24 CDT
> 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