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"?
In <blbnnr$gub$1_at_reader2.panix.com> Stan Brown <stanb_at_panix.com> writes:
>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?
OK, more fumbling around bu me :-( I did:
SVRMGR> alter database datafile
'/db_local1/oradata/pwhse/tables/config.dbf' online ;
Statement processed.
SVRMGR> recover database until cancel ;
ORA-00279: Change 108372033 generated at 09/23/03 23:11:37 needed for
thread 1
ORA-00289: Suggestion : /dumpdisk/archivelogs/pwhse/arch/1_2162459.dbf
ORA-00280: Change 108372033 for thread 1 is in sequence #2162459
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
and still v$backup list file 10 as:
10 RECOVER READ WRITE 108474673 20971520 20971520 /db_local1/oradata/pwhse/tables/config.dbf
What am I doing wrong here?
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Tue Sep 30 2003 - 06:05:52 CDT